uqa-sql 0.6.3

PostgreSQL-compatible SQL compiler built on libpg_query
Documentation
//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

pub(super) const STATEMENTS: &[&str] = &[
    "CREATE TABLE t(a integer DEFAULT 1, b text COLLATE \"C\", CHECK (a > 0), CONSTRAINT pk PRIMARY KEY(a))",
    "CREATE TABLE IF NOT EXISTS t(a integer)",
    "CREATE INDEX idx ON t(a) WHERE a > 0",
    "ALTER INDEX idx RENAME TO other_idx",
    "INSERT INTO t(a) VALUES (1) ON CONFLICT(a) DO UPDATE SET a = excluded.a RETURNING a",
    "UPDATE t SET a = (SELECT 2) WHERE a > 0 RETURNING a",
    "DELETE FROM t WHERE a > 0 RETURNING a",
    "DROP TABLE IF EXISTS t CASCADE",
    "ALTER TABLE t ADD COLUMN b text DEFAULT 'b', ADD CONSTRAINT checked CHECK (a > 0)",
    "ALTER VIEW v SET (security_barrier = true)",
    "CREATE OR REPLACE VIEW v(a) WITH (security_barrier = true) AS SELECT 1",
    "CREATE MATERIALIZED VIEW mv(a) AS SELECT 1 WITH NO DATA",
    "REFRESH MATERIALIZED VIEW CONCURRENTLY mv WITH DATA",
    "CREATE SCHEMA IF NOT EXISTS s AUTHORIZATION owner",
    "ALTER SCHEMA s OWNER TO other_owner",
    "ALTER SCHEMA s RENAME TO new_s",
    "NOTIFY channel, 'payload'",
    "LISTEN channel",
    "UNLISTEN channel",
    "SET LOCAL application_name = 'name'",
    "RESET application_name",
    "RESET ALL",
    "SET CONSTRAINTS first_constraint, second_constraint DEFERRED",
    "SHOW application_name",
    "DISCARD PLANS",
    "LOAD 'library'",
    "EXPLAIN (ANALYZE, MEMORY, FORMAT JSON) SELECT 1",
    "ANALYZE t",
    "VACUUM (ANALYZE, VERBOSE) t(a)",
    "LOCK TABLE t, u IN SHARE MODE NOWAIT",
    "TRUNCATE TABLE t, u RESTART IDENTITY CASCADE",
    "BEGIN ISOLATION LEVEL REPEATABLE READ READ ONLY",
    "DECLARE c BINARY NO SCROLL CURSOR WITH HOLD FOR SELECT 1",
    "FETCH BACKWARD 2 FROM c",
    "CLOSE c",
    "CREATE SEQUENCE seq AS bigint INCREMENT 2 MINVALUE 1 MAXVALUE 99 START 3 CACHE 1 CYCLE",
    "CREATE DOMAIN positive AS integer DEFAULT 1 CHECK (VALUE > 0)",
    "ALTER DOMAIN positive ADD CONSTRAINT upper_bound CHECK (VALUE < 10)",
    "CREATE TYPE shell",
    "COMMENT ON TYPE shell IS 'type comment'",
    "CREATE TYPE mood AS ENUM ('good', 'bad')",
    "CREATE TYPE pair AS (a integer, b text)",
    "ALTER TYPE mood ADD VALUE 'neutral' BEFORE 'bad'",
    "ALTER TYPE pair ADD ATTRIBUTE c integer",
    "GRANT USAGE ON TYPE pair TO reader WITH GRANT OPTION",
    "ALTER SEQUENCE seq RESTART WITH 7",
    "CREATE TEMP TABLE copy(a) ON COMMIT DROP AS SELECT 1 WITH NO DATA",
    "PREPARE p(integer) AS SELECT $1 + 1",
    "EXECUTE p(1 + 2)",
    "DEALLOCATE p",
    "CREATE FOREIGN DATA WRAPPER wrapper NO HANDLER NO VALIDATOR OPTIONS (endpoint 'local')",
    "CREATE SERVER remote TYPE 'kind' VERSION '1' FOREIGN DATA WRAPPER wrapper OPTIONS (endpoint 'local')",
    "CREATE FOREIGN TABLE remote_t(a integer OPTIONS (name 'field')) SERVER remote OPTIONS (name 'table')",
    "ALTER FOREIGN TABLE remote_t OWNER TO owner",
    "MERGE INTO t USING u ON t.a = u.a WHEN MATCHED THEN UPDATE SET a = u.a WHEN NOT MATCHED THEN INSERT (a) VALUES(u.a)",
    "CREATE FUNCTION f(a integer DEFAULT 1) RETURNS integer LANGUAGE SQL IMMUTABLE AS 'SELECT a + 1'",
    "CREATE FUNCTION block(a integer) RETURNS integer LANGUAGE SQL BEGIN ATOMIC SELECT a + 1; END",
    "DROP FUNCTION IF EXISTS f(integer) CASCADE",
    "ALTER FUNCTION f(integer) STABLE SET search_path TO public",
    "ALTER FUNCTION f(integer) OWNER TO owner",
    "ALTER FUNCTION f(integer) RENAME TO new_f",
    "GRANT EXECUTE ON FUNCTION f(integer) TO reader WITH GRANT OPTION",
    "GRANT SELECT(a), UPDATE ON TABLE t TO reader WITH GRANT OPTION",
    "GRANT USAGE ON SEQUENCE seq TO reader",
    "GRANT CONNECT ON DATABASE db TO reader",
    "GRANT USAGE ON SCHEMA s TO reader",
    "GRANT writer TO reader WITH ADMIN OPTION",
    "CREATE ROLE reader WITH LOGIN INHERIT CREATEDB CONNECTION LIMIT 3 IN ROLE parent ROLE member ADMIN administrator",
    "ALTER ROLE reader WITH NOLOGIN NOCREATEDB CONNECTION LIMIT 2",
    "ALTER ROLE reader RENAME TO reader2",
    "DROP ROLE IF EXISTS reader",
    "CREATE TRIGGER trigger_name BEFORE INSERT OR UPDATE OF a ON t FOR EACH ROW WHEN (NEW.a > 0) EXECUTE FUNCTION triggered('argument')",
    "DROP TRIGGER IF EXISTS trigger_name ON t CASCADE",
    "CREATE RULE rule_name AS ON UPDATE TO t WHERE OLD.a > 0 DO ALSO (INSERT INTO log VALUES(NEW.a); UPDATE counts SET n = n + 1)",
    "DROP RULE IF EXISTS rule_name ON t CASCADE",
    "DO LANGUAGE plpgsql $$ BEGIN RAISE NOTICE 'hello'; END $$",
    "CALL procedure_name(1, named => 'argument')",
    "SELECT a, sum(a) OVER w FROM t WINDOW w AS (PARTITION BY b ORDER BY a ROWS BETWEEN 1 PRECEDING AND CURRENT ROW)",
    "WITH RECURSIVE q(a) AS (VALUES(1) UNION ALL SELECT a + 1 FROM q WHERE a < 3) SELECT a FROM q",
];