SQL/PSM

1 program Added 2026-02-24T20:47:44Z Agent: claude-codeModel: claude-sonnet-4-6WebSearch: enabled Evidence Report issue View issues
Aliases: SQL PL, SQL Persistent Stored Modules
Provenance: commit f09a082d0a · authored 2026-02-24T21:48:31+01:00 · agent claude-code · model claude-sonnet-4-6

Sources mentioning this language

3 sources · pl_id: pl/sql-psm-2
LLM (this repo) · 1WikipediaWikidata · Q4048876

Wikipedia infobox ↗

Pulled from the wikimedia/structured-wikipedia snapshot — see data/raw/wikipedia_pl_facts.*.jsonl and pl_fact.csv for the long-table provenance.

Paradigmsmulti-paradigm
First appeared1996
Influenced byPL/SQL Ada

Related languages

PS-algol (0.21)SQL (0.13)JPQL (0.12)SQL PL (0.12)Modula-2+ (0.12)

Real programs from Software Heritage

No SWH evidence indexed yet for this language. (Either the SWH mining hasn't reached this language's extensions, or no matching files exist in the archive.)

Programs collected by LLM agents experimental · unverified

Gathered by LLM agents during the experiment that started this catalogue. They are not verified: the agent names an origin, but a program can be altered or invented — an audit found one attributed to a file that does not exist, in a syntax the language does not have. Prefer the programs archived by Software Heritage above. The catalogue's goal is the languages themselves, grounded in sources (PLDB, Wikipedia, Rosetta Code, …), with real archived programs; these examples may be dropped.

Loops/While

Provenance: commit f09a082d0a · authored 2026-02-24T21:48:31+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch enabled
code.sql · license: Public Domain · added: 2026-02-24T20:47:44Z
CREATE PROCEDURE LOOPSWHILE()
LANGUAGE SQL
BEGIN
  DECLARE i INT DEFAULT 1024;
  WHILE i > 0 DO
    SELECT i;
    SET i = i / 2;
  END WHILE;
END

Contribute — propose a file extension

Tell us where to find evidence about SQL/PSM (mapped to pl/sql-psm-2). A reference URL is required; at least one of extension or program code must be provided too. A maintainer reviews each submission via a draft PR before anything lands.
Optional: attach a program from that URL
If the reference URL points at a single source file you'd like to add as an example program, paste it below. The workflow will write it under languages/SQL_PSM/programs/<sha>/. Keep under ~200 lines.
(or open the pre-filled issue directly)
← sql-psm sqlalchemy →