On this page
Do not assume PostgreSQL (or any other database) behavior from similar syntax. This page is the implementation-derived record.
Implemented#
DDL/DML above; joins incl. lateral; subqueries incl. correlated EXISTS; WITH [RECURSIVE]; set ops; window functions with PARTITION BY/ORDER BY/ROWS|RANGE|GROUPS frames; GROUPING SETS/ROLLUP/CUBE; DISTINCT [ON]; FILTER; JSON operators/constructors/JSON_TABLE; temporal literals/arithmetic/EXTRACT; ON CONFLICT; RETURNING; EXPLAIN [ANALYZE]; COPY … STDIN/STDOUT (wire); SET/SHOW/DESCRIBE/USE; sequences + nextval/currval; ENUM/DOMAIN/composite types; pg_catalog/information_schema live rows.
Partial#
ILIKEparses but behaves as case-sensitiveLIKE(verified:SELECT 'ABC' ILIKE 'abc'returns false). Uselower(x) LIKE lower(y)until this is fixed.FOR UPDATEaccepted, ignored.AND/ORuse is-true checks:NULL AND TRUE → false(differs from strict 3VL).CREATE FUNCTION/PROCEDURE/TRIGGER/EXTENSION/MATERIALIZED VIEWparse to stubs without execution.VACUUMruns accounted maintenance (64-mutation policy, fails closed; explicitVACUUMungated). Freshness signals:plomid_stat_counters().tables_staleandplomid_stat_tables().is_staleshow which tables have writes waiting to be folded into the fast copy.ANALYZEcollects real table statistics (row/null/distinct/min/max, persisted).REINDEX/LOCK/CLUSTER/REFRESH/LISTEN/NOTIFYparse; mostly no engine effect.UPDATE…FROM/COPYunsupported inside explicit transactions.CREATE/DROP DATABASEunsupported inside explicit transactions (refused with a descriptive error); run them in autocommit.TABLE name(shorthandSELECT),TABLESAMPLE, SQL-spelledPREPARE/EXECUTE,RESET/RESET ALL, andDISCARD ALLare not supported (syntax errors). UseSELECT * FROM nameinstead ofTABLE; disable pooler checkoutRESET/DISCARDstatements or expect failures. Extended-protocol prepared statements (Parse/Bind/Describe/Execute) are supported — only the SQL-spelledPREPAREis missing.- Bare
VALUES (…), (…)as a standalone query is not supported; use it as anINSERTsource or aSELECTunion instead. LIMIT/OFFSETonly integer literal or cast.
Unsupported / not available in v0.1.0#
Foreign-key enforcement, RENAME DATABASE, DROP ROLE / DROP USER, setval(), file COPY, cursors, stored-procedure execution, plpgsql beyond DO/PERFORM/RAISE subset, graph/blob types, multi-region/distributed, continuous aggregates/retention/downsampling, binary wire values (text only, except vector results which support binary format for binary-encodable shapes; vector parameters are text-only and binary params fail closed). Dense vector column types are supported with literals, distance operators, top-k, and ANN — see Vector search. TLS transport is supported (verified sslmode=require handshake) — see TLS.
Different behavior worth knowing#
COUNT(DISTINCT)dedups byto_sql_text(1≡1.0).AVG(int)returns normalizedNumeric(PG typing preserved deliberately).- Server default password is
plomid; CLI default password issecret;start.shdefault issecret. Always set explicitly. - No compatibility percentage is claimed. Wire + OID + catalog similarity does not imply semantic compatibility.