thecodingmachine / magic-query

A very clever library to use SQL prepared statement with a variable number of parameters... and much more!
http://mouf-php.com/packages/mouf/magic-query/README.md
22 stars 14 forks source link

Add the ability to output in a chosen dialect #55

Closed moufmouf closed 5 years ago

moufmouf commented 5 years ago

By default, MagicQuery outputs SQL in the dialect of the connection passed in parameter.

So if PostgreSQL is used, items will be quoted with ". This is more than logical.

But in some rare cases, we might want to output in the MySQL dialect instead. This is true if the SQL outputed is to be reused in MagicQuery itself. Since MagicQuery only parses MySQL dialect, we might need a way to tell MagicQuery to output MySQL dialect rather than native dialect.

moufmouf commented 5 years ago

Done in #56 and #57