Examples or real-world SQL

[nene]

That's just a placeholder issue to reference some examples of real SQL in the wild. So I can better prioritize which parts of syntax to support.

PostgreSQL

• https://github.com/giveffektivt/donation-platform/blob/main/db/migrations/99999999999999_views.sql features the following missing bits:
  • DROP FUNCTION with multiple function names.
  • CREATE RULE statement
  • interval literal with unit, e.g. interval '1' month
  • year and month used as identifier
  • FULL [OUTER] JOIN
• Supabase SQL export. Contains the following unsupported bits:
  • SET row_security = off, SET standard_conforming_strings = on, etc
  • RESET ALL
  • CREATE EXTENSION IF NOT EXISTS "pg_net" WITH SCHEMA "extensions"
  • COMMENT ON SCHEMA "public" IS 'standard public schema'
  • Namespaced data type name in table column definitions and elsewhere (like "public"."my_enum").
  • ALTER PUBLICATION "supabase_realtime" OWNER TO "postgres"
  • ALTER DEFAULT PRIVILEGES FOR ROLE "postgres" IN SCHEMA "public" GRANT ALL ON SEQUENCES TO "postgres"