spacetimedb-sql

Use this skill for SQL syntax and query behavior.

Core SQL split

Subscription SQL is stricter than ad hoc query/DML SQL:

• Subscription form is SELECT projection FROM relation [WHERE predicate].
• Subscriptions return full rows from one table only: SELECT * or SELECT table.*.
• Subscriptions can reference at most two tables with one join, and join columns must be indexed.
• Subscriptions do not support INSERT, UPDATE, DELETE, column projections, arithmetic expressions, or arbitrary joins.

Ad hoc SQL via CLI/HTTP supports:

• SELECT with column projections, COUNT(*), joins, WHERE, and LIMIT.
• INSERT INTO table (columns...) VALUES (...).
• DELETE FROM table [WHERE ...]; no joins.
• UPDATE table SET column = literal [WHERE ...]; no joins.
• Experimental SET and SHOW system-variable statements.