synatic / noql

Converts SQL queries to Mongo find or aggregates
https://noql.synatic.dev/
GNU General Public License v3.0
46 stars 12 forks source link

Upgrading parser library, adding support for CURRENT_DATE and NOT LIKE #87

Closed eXigentCoder closed 1 year ago

eXigentCoder commented 1 year ago

The node-sql-parser library was quite a bit behind and contained a bunch of fixes for issues in parsing sql statements. Most notably with postgresql column and table names wrapped with either a double or single quote. Upgrading this allows us to fix a bunch of downstream bugs that were caused by incorrect parsing.

The library now supports NOT LIKE statements in both the query and where clause. The library now allows you to use the CURRENT_DATE() function in either the where or query clause.