Sql Pg

Complex queries can be written with normal SQL, including the values needs to be bound and prefixed with the sql tag.
Alternatives To Sql Pg
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
15 hours ago1June 08, 20223,028otherClojure
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
10 hours ago1,746apache-2.0Java
Free universal database tool and SQL client
a day ago2May 05, 2020791bsd-2-clausePython
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Directus21,761508 hours ago55September 22, 2022229otherTypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
4a day ago37July 12, 2022207mitHaskell
REST API for any Postgres database
Shardingsphere18,45488 hours ago7June 04, 2020666apache-2.0Java
Ecosystem to transform any database into a distributed database system, and enhance it with sharding, elastic scaling, encryption features & more
Knex17,61418,0962,7883 days ago248August 31, 2022830mitJavaScript
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
18 hours ago758otherRust
📊 Cube — The Semantic Layer for Building Data Applications
10 hours ago218otherJava
🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码,前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.
14 hours ago533otherC
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
Alternatives To Sql Pg
Select To Compare

Alternative Project Comparisons

Build Status Coverage Status

Latest Release: v10.4.1, Latest Major Release: v10.0.0, All Releases


Complex queries can be written with normal SQL, including the values needs to be bound and prefixed with the sql tag.

SQL Make the id variable? SQL
Or even more simple? SQL


  • Built on top of pg as database driver
  • Simple data manipulation and selection methods without the need to write SQL
  • SQL Tag and Tag Helpers to write queries looks like native SQL and be secure by design
  • Write easy unit testable queries
  • Possibility to add own Tag Helpers to extend the functionality


npm install --save pg sql-pg


Use it in your project:

const sql = require('sql-pg')()

The connection use per default the env var DATABASE_URL. It will only establish a database connection if manipulation/selection methods are used. Alternatively it's possible to provide a sql.js to customize the database connecting and sql object initializing.


Manipulation Methods

Simple data manipulation can be done without writing any SQL Statements.

E.g. some user data manipulation:

const id = await sql.insert(
  { name: 'Sharaal', email: '[email protected]', passwordhash: '...' }

await sql.update('users', { validated: 1 }, { id })

await sql.delete('users', { id })

More complex data manipulation can be done with the SQL Tag.

Selection Methods

Often needed convenient methods to check and extract query results are available with the Selection Methods.

E.g. select all not validated users:

const users = await sql.any('users', ['name', 'email'], { validated: 0 })

Also the Selection Methods supports SQL Tag as parameter for more complex selections. Because they are highly inspired by pg-promise, there are the Selection Methods any/manyOrNone, many, oneOrNone and one available.

SQL Tag and Tag Helpers

If it becomes more complex the SQL Tag and Tag Helpers are the way to go.

They are as near as possible to native SQL queries to be readable and easy to write. All variables can be directly used and will be exchanged via placeholders and given to the database separately as values. For non native values like lists, for table/column names and conditions there are Tag Helpers.

E.g. list of not activated users filtered by name:

const name = 'raa'

const users = await sql.any(
    SELECT "name", "email" FROM "users"
        "validated" = 0
        "name" LIKE ${`%${name}%`}

There are a lot more Tag Helpers available like .identifier, .table, .column(s), .value(s), .valuesList, .assignments, .conditions, .limit, .offset, .pagination, .if, .jsonColumnObject and .jsonColumnText.


Alternative initialization, available Tag Helpers, Nested Queries, Transaction, Writing Tag Helpers, Migrations, Syntax Highlighting in Atom... All additional documentation can be found in the Wiki.


Found a bug or missing a feature? -> Create a new Issue

Found a security issue? -> Look at the Security Policy

Having questions, want to give feedback or talk to me? -> E-Mail me [email protected]

Popular Sql Projects
Popular Postgresql Projects
Popular Data Processing Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Query Builder