argia
v0.3.0
Published
Alternative query syntax that converts to raw SQL
Downloads
3
Readme
Argia easy SQL converter
Alternative query syntax that converts to raw SQL
Usage
const argia = require("argia")
const sql = argia("users(id,title,age)") // SELECT id, title, age FROM users
const rows = await adapter.query(sql)
Examples
Select
| Argia SQL | SQL | | ------ | ------ | | users(*) | SELECT * FROM users | | users(id,title,age) | SELECT id, title, age FROM users | | users(id,title,age){3} | SELECT id, title, age FROM users LIMIT 3 | | users(id,title,age){3,1} | SELECT id, title, age FROM users ORDER BY title LIMIT 3 OFFSET 1 | | users(id,title,age){3,1}<-age> | SELECT id, title, age FROM users ORDER BY age DESC LIMIT 3 OFFSET 1 |
Insert
| Argia SQL | SQL | | ------ | ------ | | ('John Doe'|33)>users(name, age) | INSERT INTO users (name, age) VALUES ('John Doe', 33) |