Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Getting Started
Learn the Basics
Roadmap
Tutorials
Installation Guide
Subqueries
Stored Procedures
Stored Procedures in PL/SQL
Stored Procedures in Rhai
Stored Procedures in JavaScript
Stored Procedures in Python
Event Triggers
How to Guides
How to use SQL Functions
Date and Time Handling
Creating Dynamic Web Pages with Jinja
Using the Auto-API JSON Layer
Analyze Queries with EXPLAIN
Parameter Binding
References
SQL Commands
Connection String Reference
Embedded API Reference
Data Types in Oxibase
Constraints
Stored Procedures
Stored Procedures in PL/SQL
Stored Procedures in Rhai
Stored Procedures in JavaScript
Stored Procedures in Python
Triggers
Functions
Scalar Functions
Aggregate Functions
Window Functions
User-Defined Functions
PRAGMA Commands
Schema Management in Oxibase
SQL Features
Temporal Queries (AS OF)
JOIN Operations
Subqueries
Common Table Expressions (CTEs)
ROLLUP, CUBE, and GROUPING SETS
Operators and Expressions
CAST Operations
DISTINCT Operations
ON DUPLICATE KEY UPDATE
Savepoints
Explanations
Architecture
Architecture Overview
Storage Engine
Indexing
MVCC Implementation
Transaction Isolation
Expression Pushdown
Persistence
Unique Indexes
Performance
Performance Optimization
Query Optimizer
Semantic Query Cache
Query Execution and Optimization in Oxibase
Parallel Execution
Unikernel
NULL Handling
GitHub
SQL Features
References
SQL Features
SQL Features
Advanced SQL features supported by Oxibase, including CTEs, subqueries, joins, and more.
Table of contents
Temporal Queries (AS OF)
JOIN Operations
Subqueries
Common Table Expressions (CTEs)
ROLLUP, CUBE, and GROUPING SETS
Operators and Expressions
CAST Operations
DISTINCT Operations
ON DUPLICATE KEY UPDATE
Savepoints