Make named parameters posible

[s9gf4ult]

Make named parameters posible

[smoothdeveloper]

Regarding the special query parser, it seems to me that it's not really needed as it's sql implementation specific, sqlite supports different syntaxes (http://www.sqlite.org/lang_expr.html#varparam), sql server uses @paramName, etc.

That is unless we want to have a syntax specific to hdbi and have driver implementation performs the translation to the implementation specific notation, it should also support sql implementation specific / pass through.

It's a good idea to have statements almost ready to execute outside of haskell by putting it in a query / management tool; if there is a special syntax, one would need to perform additional changes before running the query in the external tool.

[s9gf4ult]

There is method runRaw in Connection. It performs raw query without any transformations. But this query can not get parameter while it is raw and parameters must be already substitued.

I think that special syntax is good because as you say all databases have it's own query syntax for named parameters. It looks logical if you can perform one query with one syntax on different databases.