grncdr/node-any-db-adapter-spec — pull request #7 by Hypermediaisobar-admin (2014-09-24 10:58:50+00:00)
Title: Proposal for named parameters

Hi,

Here's a proposal to implement support for named parameters.
AFAIK, only PostgreSQL does not support them, but they could be optional.

We already have them in MSSQL adapter, but it probably would be better to have them as a part of specification :).

This also introduces adapter property for positional parameter marker, which should return string that is used as a marker in SQL queries, e.g., '?'. Any-DB supports positional parameters, but does not offer any way for users to know, what character/string is used to put them into SQL query.

BTW Query description does not mark params as optional. Is that intentional?