Skip to main content

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.

Views are virtual tables based on query results.

​
Basic Syntax

:CREATE VIEW ViewName AS GET Entity WHERE condition
:ALTER VIEW ViewName AS GET Entity WHERE condition
:DROP VIEW ViewName

​
Create View

:CREATE VIEW ActiveUser AS GET User WHERE active = true
DatabaseOutput
PostgreSQLCREATE VIEW activeuser AS SELECT * FROM users WHERE active = true
MySQLCREATE VIEW activeuser AS SELECT * FROM users WHERE active = true

​
View with Columns

:CREATE VIEW UserSummary AS GET id, name, email FROM User WHERE active = true
DatabaseOutput
PostgreSQLCREATE VIEW usersummary AS SELECT id, name, email FROM users WHERE active = true

​
View with Aggregation

:CREATE VIEW OrderTotals AS GET Order WITH user_id, SUM(amount) AS total_spent GROUP BY user_id
DatabaseOutput
PostgreSQLCREATE VIEW ordertotals AS SELECT user_id, SUM(amount) AS total_spent FROM orders GROUP BY user_id
Views with COUNT(*) require native SQL. Use SUM, AVG, MIN, MAX with OmniQL views.

​
Query a View

Views are queried like regular tables. 
:GET ActiveUser WHERE role = "admin"
:GET OrderTotals WHERE total_spent > 1000

​
Alter View

Update an existing view definition. 
:ALTER VIEW ActiveUser AS GET User WHERE active = true AND verified = true
DatabaseOutput
PostgreSQLCREATE OR REPLACE VIEW activeuser AS SELECT * FROM users WHERE active = true AND verified = true
MySQLCREATE OR REPLACE VIEW activeuser AS SELECT * FROM users WHERE active = true AND verified = true

​
Drop View

:DROP VIEW ActiveUser
DatabaseOutput
PostgreSQLDROP VIEW IF EXISTS activeuser
MySQLDROP VIEW IF EXISTS activeuser

​
Complete Examples

​
Active Premium Users

:CREATE VIEW PremiumUser AS GET id, name, email, created_at FROM User WHERE role = "premium" AND active = true

​
Low Stock Products

:CREATE VIEW LowStock AS GET id, name, sku, quantity FROM Product WHERE quantity < 10 AND active = true

​
Revenue by Status

:CREATE VIEW RevenueByStatus AS GET Order WITH status, SUM(total) AS revenue GROUP BY status

​
Limitations

Current view implementation supports:
  • Simple SELECT queries with WHERE, ORDER BY, LIMIT
  • Column selection
  • Aggregations with SUM, AVG, MIN, MAX
Not currently supported in OmniQL views:
  • COUNT(*) aggregations (use native SQL)
  • Views with JOINs (use native SQL)
  • Materialized views (PostgreSQL-specific, use native SQL)
  • CREATE OR REPLACE (use ALTER VIEW instead)

​
MongoDB Note

MongoDB does not support traditional views. Use aggregation pipelines or read-only collections for similar functionality.

​
Next Steps

Indexes

Optimize query performance

Transactions

Group operations safely