Postgres.js is a fast, full-featured node and deno client for PostgreSQL databases. It uses ES6 Tagged Template Strings at its core, providing a simple surface API for executing SQL queries. The library supports dynamic query building, transactions, data transformation, and real-time communication with the database. It also offers advanced features like dynamic column selection, dynamic inserts, and multiple updates in one query. Postgres.js emphasizes security by automatically handling query parameters to prevent SQL injection attacks. It provides various query methods and supports streaming queries. The library can be easily installed and used in any project.
https://github.com/porsager/postgres