SQL Reference Overview

ScramDB aims to provide compatibility with the PostgreSQL dialect of SQL, allowing you to leverage familiar syntax and tools. The underlying ScramVM query engine processes these SQL commands.

This section details the currently supported SQL commands and specific extensions provided by the Pulsejet.AI platform.

Key Areas:

• Data Definition Language (DDL): Commands for creating and managing database objects like tables.
  • CREATE TABLE: Define internal tables stored within ScramDB’s embedded Tundra engine.
  • CREATE EXTERNAL TABLE: Define tables that reference data stored outside ScramDB (e.g., Parquet, CSV files).
  • DROP TABLE: Remove internal or external table definitions.
• Integration Management: Commands for creating and managing integrations with external systems.
  • CREATE STORAGE INTEGRATION: Define integrations with external storage systems (S3, GCS, Azure).
  • DROP STORAGE INTEGRATION: Remove storage integration definitions.
  • CREATE CATALOG INTEGRATION: Define integrations with external metadata catalogs (Glue, Iceberg REST, Object Storage).
  • DROP CATALOG INTEGRATION: Remove catalog integration definitions.
• Data Query Language (DQL): Commands for retrieving data.
  • SELECT: Query data from tables, including filtering (WHERE), aggregation (GROUP BY), sorting (ORDER BY), and joins (LEFT|RIGHT|FULL JOIN).
• AI Extensions: Platform-specific commands for AI integration.
  • ASK: Perform natural language queries against your data.
• Information Schema: Standard schema providing metadata about database objects.
  • INFORMATION_SCHEMA: Query tables and columns views.
  • INFORMATION_SCHEMA Extensions: Query storage_integrations and catalog_integrations views.

We are PostgreSQL wire compatible, we aren’t using exact PostgreSQL syntax. Please note that not all PostgreSQL functions and features may be implemented yet. Refer to the specific command pages for details on supported syntax and current limitations.