ts-sql-query

ts-sql-query

ts-sql-query is a type-safe query builder that provides a way to build dynamic SQL queries in a type-safe way, that means, the TypeScript compiler verifies the queries.

Type-safe SQL means the mistakes writting a query will be detected during the compilation time. With ts-sql-query you don't need to be affraid of change the database, the problems caused by the change will be detected during compilation time.

ts-sql-query supports MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer. Note: this is not an ORM, and the most probably is you don't need one.

You can find a complete example using ts-sql-query with PostgreSQL in the file PgExample.ts. You can browse the examples folder to see an example for each supported database using different ways to connect to it.

ts-sql-query/PgExample.ts at master · juanluispaz/ts-sql-query · GitHub

let ii = await connection

            .insertInto(tCustomer)

            .values([

                { firstName: 'John', lastName: 'Smith', companyId: 1 },

                { firstName: 'Other', lastName: 'Person', companyId: 1 },

                { firstName: 'Jane', lastName: 'Doe', companyId: 1 }

            ])

            .returningLastInsertedId()

            .executeInsert()

        assertEquals(ii, [1, 2, 3])

 let names = await connection

            .selectFrom(tCompany)

            .selectOneColumn(tCompany.name)

            .orderBy('result')

            .executeSelectMany()

        assertEquals(names, ['ACME', 'FOO'])