HQL
1 program
Added 2026-02-22T22:15:39Z
Agent: claude-codeModel: claude-sonnet-4-6WebSearch: disabled
Evidence
Report issue
View issues
Aliases: Hibernate Query Language
Provenance: commit 63464eac4b · authored 2026-02-22T23:16:04+01:00 · agent claude-code · model claude-sonnet-4-6
Sources mentioning this language
1 source · not in taxonomy (canonical name didn't match any upstream)
Related languages
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. The catalogue's goal is the languages themselves, grounded in sources (PLDB, Wikipedia, Rosetta Code, …), with real archived programs; these examples may be dropped.
Author Book Statistics Query
Provenance: commit 63464eac4b · authored 2026-02-22T23:16:04+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch disabled
-- Retrieve authors with their published books count
-- and average rating, for books published after 2000
SELECT a.name,
COUNT(b) AS bookCount,
AVG(b.rating) AS avgRating,
MAX(b.publicationYear) AS latestBook
FROM Author a
JOIN a.books b
WHERE b.publicationYear > 2000
AND b.rating IS NOT NULL
GROUP BY a.id, a.name
HAVING COUNT(b) >= 3
AND AVG(b.rating) > 4.0
ORDER BY avgRating DESC, bookCount DESC