​

What is OmniQL?

// Your database connection
db, _ := sql.Open("postgres", "postgres://localhost/mydb")

// Wrap it with OmniQL
client := oql.WrapSQL(db, "PostgreSQL")

// Query with universal syntax
users, _ := client.Query(":GET User WHERE age > 21")

​

Why OmniQL?

​

Key Features

• Universal Syntax: Learn one syntax (:GET, :CREATE, :UPDATE, :DELETE) instead of memorizing SQL dialects, BSON maps, and Redis commands.
• Plug and Play: Wrap your existing database connection with WrapSQL(), WrapMongo(), or WrapRedis() and start querying immediately.
• Zero Overhead: OmniQL translates queries instantly. No ORM magic, no reflection—just native query strings executed by your standard drivers.
• TrueAST Architecture: Queries are parsed into a recursive Abstract Syntax Tree, enabling complex nested expressions and type safety.
• Polyglot Persistence: Use relational, document, and key-value stores with the same query syntax.

​

Supported Databases

​

How It Works

1. Wrap: Connect OmniQL to your existing database connection.
2. Query: Pass an OmniQL string (starting with :) to client.Query().
3. Compile: The parser validates syntax and builds the AST.
4. Translate: The translator generates native commands for your database.
5. Execute: OmniQL runs the query and returns results as []map[string]any.

​

Quick Example

package main

import (
    "database/sql"
    "fmt"
    
    _ "github.com/lib/pq"
    "github.com/omniql-engine/omniql"
)

func main() {
    // Your existing connection
    db, _ := sql.Open("postgres", "postgres://localhost/mydb")
    
    // Wrap with OmniQL
    client := oql.WrapSQL(db, "PostgreSQL")
    
    // CRUD operations
    client.Query(`:CREATE User WITH name:"Alice", age:25`)
    
    users, _ := client.Query(":GET User WHERE age > 21")
    for _, user := range users {
        fmt.Println(user["name"], user["age"])
    }
    
    client.Query(`:UPDATE User SET verified:true WHERE name = "Alice"`)
    
    client.Query(`:DELETE User WHERE active = false`)
}

​

Next Steps