kiss-orm
libsqldb
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
kiss-orm
-
Request for learning resources: Using template literal types for parsing SQL queries in the type system
I found this: https://github.com/Seb-C/kiss-orm
-
I don't want to learn your garbage query language
I totally agree with the views of the author. That is basically why I started to build an ORM that does not include a query builder. Best of both worlds.
Now the design was far from easy, and keeping things reasonably simple without abstracting the SQL part was my biggest challenge. And this would not have been possible without the template-string tagging feature of modern JS, so it wouldn't be doable for many other languages.
https://github.com/Seb-C/kiss-orm
libsqldb
- Where did the notion of "one return only" come from?
-
I don't want to learn your garbage query language
> My current comfort zone is if I can find a query builder that has enough static typing that it has all of the keywords of my preferred SQL flavor, has prepared statements with placeholders- mainly for safety/security, and basically returns a string when you're done.
Some self-promotion (shameless, I know): https://github.com/lelanthran/libsqldb/tree/v1.0.0-rc2
I'm intending to rewrite it ("the first one is always to throw away" - I put too much unnecessary functionality into it and not enough RDBMS server backends) but I've used it in a few projects (use the latest branch) and am happy with it for postgres or sqlite usage.
See https://github.com/lelanthran/libsqldb/blob/v1.0.0-rc2/src/s... for example usage, but the basic premise is:
1. Send parameterised string to DB.
What are some alternatives?
SqlKata Query Builder - SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
sqlpp11 - A type safe SQL template library for C++
sqlx - general purpose extensions to golang's database/sql
pgtyped - pgTyped - Typesafe SQL in TypeScript
honeysql - Turn Clojure data structures into SQL
iterlib - Iterator library.
pggen - Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
Tequel
ts-sql - A SQL database implemented purely in TypeScript type annotations.