sql-concat
sql-concat copied to clipboard
A MySQL query builder
A few parts in the README looked incorrect/improvable.
``` js q.where('some_column', 14) .where(q.group('OR') .compare('column_a', someDate) .compare('column_b', '>' someDate) .like('column_c', someValue) .compare('column_d', null) ) // => WHERE some_column = ? // AND (column_a = ? OR column_b > ?...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html Add a function for optimizer hint queries? I don't think I can do `query.select('/*+ INDEX(table_alias foreign_key) */')` or it would add a comma after it. What API do you...