On Sunday, 25 February 2018 at 09:23:18 UTC, rikki cattermole
wrote:
On IRC earlier today we discussed database libs a bit, we
agreed that both "?" and "@name" needed to be supported. No
other suggestions came up. We don't really need a third or
fourth form I think.
"@name"? Which DBMS uses that? Although Denis said Postgres uses
$1, PG also supports :name, in either the command line tool
(psql) and the procedural language PL/pgSQL. Personally, I
prefer what Python's PEP 249 calls 'format' (%s) or 'pyformat'
(%(name)s). Note that although the %s appears in the SQL string,
the actual arguments are passed separately at invocation time, as
either tuples or dicts (associative arrays).
Joe
