1.0.23 • Published 8 months ago
qql v1.0.23
QQL
QQL is a query builder.
All queries are plain javascript object. One of the benefits of this is that they can easily be serialized and sent in a call to a server. The goal is that it should be possible, in the context of a web app, to access the database directly from the client as well as from the server, with the same API. There is also a permission based view system, to allow the correct access depending on the context, even if the API is the same.
Example
let qql=createQql({
sqlite: new sqlite3.Database(':memory:'),
tables: {
// ... schema def here ...
}
});
await qql({insertInto: "users", set: {name: "alice"}});
let result=await qql({manyFrom: "users", where: {name: "alice"}});
await qql({update: "users", set: {name: "bob"}, where: {name: "alice"}});
await qql({deleteFrom: "users", where: {name: "bob"}});
Schema and migration
1.0.19
8 months ago
1.0.18
9 months ago
1.0.22
8 months ago
1.0.21
8 months ago
1.0.20
8 months ago
1.0.23
8 months ago
1.0.17
10 months ago
1.0.16
10 months ago
1.0.11
11 months ago
1.0.15
11 months ago
1.0.14
11 months ago
1.0.13
11 months ago
1.0.12
11 months ago
1.0.9
1 year ago
1.0.10
1 year ago
1.0.8
1 year ago
1.0.7
1 year ago
1.0.6
1 year ago
1.0.5
1 year ago
1.0.4
1 year ago
1.0.3
1 year ago
1.0.2
1 year ago
1.0.1
1 year ago
1.0.0
2 years ago