node-red-contrib-sqlbuilder
v0.5.0
Published
A "batteries included" SQL query builder for CockroachDB, MariaDB, MSSQL, MySQL, PostgreSQL, SQLite3, Oracle DB, and Amazon Redshift
Downloads
60
Readme
SQL - Module for Node-Red
Description
A "batteries included" SQL query builder for CockroachDB, MariaDB, MSSQL, MySQL, PostgreSQL, SQLite3, Oracle DB, and Amazon Redshift designed to be flexible, portable, and fun to use.
Snapshot
Example Queries
query.select("id").from("users").where({
id: msg.user_id
})
Full Query Documentation
- https://knexjs.org/#Builder