GitHub - thebinarysearchtree/flyweight: An ORM for SQLite
Flyweight
An ORM for SQLite and NodeJS. Flyweight combines a very simple API for performing basic operations, with the ability to create SQL queries that are parsed by the ORM.
For example, if you create a query in ./database/sql/users/roles.sql that looks like this:
select
u.id,
u.name,
groupArray(r.name) as roles
from
users u join
userRoles ur on ur.userId = u.id join
roles r on ur.roleId = r.id
where
u.name = $name
group by
u.id
A function db.users.roles will be available in the API with the ...
Read more at github.com