Postgres and other database interfaces

[Joe]

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