Feature: Declarative macros in query comment blocks

[alsoLut]

What do you want to change?

/*
name: SelectStudents :many
slice: ages
*/
SELECT * FROM students WHERE age IN ($ages);

/*
name: GetAuthorByName :one
arg: name
*/
SELECT * FROM authors WHERE lower(name) = $name;

/*
name: GetStudentAndScore :one
embed: students, test_scores
*/
SELECT students.id, students.name, test_scores.*
FROM students JOIN test_scores ON test_scores.student_id = students.id;

What database engines need to be changed?

No response

What programming language backends need to be changed?

No response