{"repo":"tilyupo/qustar","free":true,"listed":false,"github":"https://github.com/tilyupo/qustar","clone":"git clone https://github.com/tilyupo/qustar.git","description":"Query SQL database through an array-like API","language":"TypeScript","stars":326,"topics":["query-builder","sql","typescript","database","javascript","mariadb","mysql","nodejs","orm","postgres"],"license":"MIT","category":"databases-storage","readme_excerpt":"Qustar Query SQL database through an array-like API. Features ✅ Expressive AND high-level query builder ✅ TypeScript support ✅ SQL databases: ✅ PostgreSQL ✅ SQLite ✅ MySQL ✅ MariaDB ⬜ SQL Server ⬜ Oracle ✅ Navigation properties ✅ Codegen free ✅ Surprise free, all queries produce 100% SQL ✅ Raw SQL ⬜ Migrations ⬜ Transactions Quick start To start using qustar with PostgreSQL (the list of all supported data sources is available below) run the following command: Here an example usage of qustar: Output: The query above will be translated to: Insert/update/delete: Supported database drivers To execute query against a database you need a connector . There are many ready to use connectors that wrap existing NodeJS drivers: - PostgreSQL - qustar-pg - SQLite - qustar-better-sqlite3 (recommended) - qustar-sqlite3 - MySQL - qustar-mysql2 - MariaDB - qustar-mysql2 If you implemented your own connector, let me know and I will add it to the list above! [//]: # 'todo: add a link to a guide for creating a custom connector' Usage Any query starts from a table or a raw sql. We will talk more about raw queries later, for now the basic usage looks like this: In qustar you compose a query by calling query methods like .filter or .map : Queries are immutable, so you can reuse them safely. For methods like .filter or .map you pass a callback which returns an expression . Expression represents a condition or operation you wish to do. Expressions are build using methods like .add or .eq : We can't us","default_branch":null,"files":null,"tree":[],"storefront":"/r/tilyupo","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tilyupo/qustar/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}