Postgres and other database interfaces

[rikki cattermole]

On 26/02/2018 5:06 AM, Joe wrote:
> 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

ADO.net uses it, and since we're trying to copy some of its features, 
that is what came up.