node-sql-query
node-sql-query copied to clipboard
dresende
NodeJS SQL query builder
option to provide dialect as a object to handle the browserify issue missing out the Dialects folder
Like I said in Topic How to get result from calculateFoundRows with "node-sql-query"?
```js const sql = sqlQuery.select() .from('machine_log') .select('when', 'machine_id', 'event') .from('machines', 'machine_id ', 'machine_log', 'machine_id') .select('name') .order('when', 'Z') .limit(limit) .build(); ``` And it produce this SQL that so wrong ```sql SELECT...
Hi, I can see activity in the changelog, but also some unmerged PRs. Also, orm2 is no longer maintained. So... are you actively maintaining this repository? It would be perfect...
Dates are stored in SQLite as Unix timestamps. Dates are represented in JavaScript as Unix timestamps. Thus, there need not be any sort of conversions. Client-side timezones are irrelevant; they...
Can be used like so var NoEscape = require("sql-query").NoEscape; var location = new NoEscape('ST_GeomFromText("POINT(30.062629699707 31.249670028687)")'); query = app.db.driver.execQuery( 'INSERT INTO users(location) VALUES(?)', [ location ], function( err, data ) {...
Hello! I'm working on an ETL project that uses node-orm2, which utilizes your query library. I would like this project to be able to talk to Microsoft SQL via Tedious...
I would like to create an UPDATE query where I update a column using a function like so UPDATE table SET col=GETDATE(); Is that possible already? I checked the tests...
Having in select clause appends before WHERE clause that cause an synax error. And it inserts column name only, but it could be an expression too.
