Views

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

Database	Output
PostgreSQL	`CREATE VIEW activeuser AS SELECT * FROM users WHERE active = true`
MySQL	`CREATE 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

Database	Output
PostgreSQL	`CREATE 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

Database	Output
PostgreSQL	`CREATE 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

Database	Output
PostgreSQL	`CREATE OR REPLACE VIEW activeuser AS SELECT * FROM users WHERE active = true AND verified = true`
MySQL	`CREATE OR REPLACE VIEW activeuser AS SELECT * FROM users WHERE active = true AND verified = true`

Drop View

:DROP VIEW ActiveUser

Database	Output
PostgreSQL	`DROP VIEW IF EXISTS activeuser`
MySQL	`DROP 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.

Getting Started

Queries

Mutations

Schema

Control

Reference

Databases

Integration

Basic Syntax

Create View

View with Columns

View with Aggregation

Query a View

Alter View

Drop View

Complete Examples

Active Premium Users

Low Stock Products

Revenue by Status

Limitations

MongoDB Note

Next Steps

Indexes

Transactions

​Basic Syntax

​Create View

​View with Columns

​View with Aggregation

​Query a View

​Alter View

​Drop View

​Complete Examples

​Active Premium Users

​Low Stock Products

​Revenue by Status

​Limitations

​MongoDB Note

​Next Steps

Indexes

Transactions

Basic Syntax

Create View

View with Columns

View with Aggregation

Query a View

Alter View

Drop View

Complete Examples

Active Premium Users

Low Stock Products

Revenue by Status

Limitations

MongoDB Note

Next Steps