Documentation Index Fetch the complete documentation index at: https://docs.omniql.com/llms.txt
Use this file to discover all available pages before exploring further.
The GET operation retrieves data from a table.
Basic Syntax : GET Entity : GET Entity WHERE conditions : GET field1, field2 FROM Entity : GET field1, field2 FROM Entity WHERE conditions
Get All Records Database Output PostgreSQL SELECT * FROM usersMySQL SELECT * FROM usersMongoDB db.users.find({})
Select Specific Columns : GET id, name , email FROM User
Database Output PostgreSQL SELECT id, name, email FROM usersMySQL SELECT id, name, email FROM usersMongoDB db.users.find({}, { id: 1, name: 1, email: 1 })
Simple WHERE Clause Database Output PostgreSQL SELECT * FROM users WHERE id = 1MySQL SELECT * FROM users WHERE id = 1MongoDB db.users.find({ id: 1 })
Multiple Conditions : GET User WHERE age > 21 AND status = "active"
Database Output PostgreSQL SELECT * FROM users WHERE age > 21 AND status = 'active'MongoDB db.users.find({ age: { $gt: 21 }, status: 'active' })
Combine Columns and Conditions : GET id, name FROM User WHERE active = true
Database Output PostgreSQL SELECT id, name FROM users WHERE active = trueMongoDB db.users.find({ active: true }, { id: 1, name: 1 })
Limit Results : GET User LIMIT 10 : GET User WHERE active = true LIMIT 5
Database Output PostgreSQL SELECT * FROM users LIMIT 10MySQL SELECT * FROM users LIMIT 10MongoDB db.users.find({}).limit(10)
: GET User LIMIT 10 OFFSET 20
Database Output PostgreSQL SELECT * FROM users LIMIT 10 OFFSET 20MongoDB db.users.find({}).skip(20).limit(10)
Standalone Aggregates Aggregates can also be used as standalone operations:
:COUNT * FROM User :COUNT * FROM User WHERE active = true :SUM amount FROM Order WHERE status = "completed" :AVG price FROM Product :MIN created_at FROM User :MAX total FROM Order
Database Output PostgreSQL SELECT COUNT(*) FROM usersPostgreSQL SELECT SUM(amount) FROM orders WHERE status = 'completed'
DISTINCT Get unique values:
: GET User DISTINCT : GET role FROM User DISTINCT
Next Steps
Filtering Advanced WHERE conditions
Sorting ORDER BY operations
