MySQL query

[pasynkov]

Can this module build a MySQL query?

example:
{ type: 'select',
table: 'some_table',
where: { id: { '$gt': 1 } }
}

pg: {
text: 'select "some_table".* from "some_table" where "some_table"."id" > $1',
values: [ 1 ]
}

but can i receive MySQL query?

mysql: {
text: 'select some_table.* from some_table where some_table.id > ?',
values: [ 1 ]
}

if not .. can i replace $n values in query? thanks for help

[jrf0110]

It currently cannot. Adding the functionality would actually be fairly easy, though.

Please see #119

I also want to say there's a way to put MySQL into a mode where it accepts the $1, $2, ... style prepared statement parameters, but I can't find it. Maybe I'm imagining that.

Hope this helps.

I'll keep this open and think about implementing a MySQL syntax this weekend.

[pasynkov]

thans, this help!

This is great SQL-builder! MySQL support will be amazing!