SQLite, My+Maria, Oracle, and SQL Server all support named parameters, some with colons, some with @ signs (: does have meaning in SQL array slices, @ does not). Postgres has no support at present.

But if you take up my suggestion for a fairly simplistic/agnostic SQL DSL, you don't need parameters, named or nameless.

On Wed, Sep 18, 2019 at 4:48 AM Lassi Kortela <xxxxxx@lassi.io> wrote:

Personally, I find it a bit questionable to pass implicitly numbered
parameters to SQL statement instead of explicitly named parameters. It
starts with things like this:

(sql-execute "insert into foo values (?, ?, ?, ?)"
(list "Thing" -123 45.67 other-stuff))

And rapidly gets worse, especially with big WHERE clauses in selects etc.

Would it be possible to support named parameters only, or are there some
DB engines or scenarios where those don't fly?