SQLite supports this with the help of a virtual table: https://github.com/0x09/sqlite-statement-vtab https://github.com/0x09/sqlite-statement-vtab Available in

SQLite supports this with the help of a virtual table: https://github.com/0x09/sqlite-statement-vtab https://github.com/0x09/sqlite-statement-vtab Available in sqlean: https://github.com/nalgeon/sqlean/blob/main/docs/define.md#table-valued-functions https://github.com/nalgeon/sqlean/blob/main/docs/define.md#t... And my Go driver: https://pkg.go.dev/github.com/ncruces/go-sqlite3/ext/statement https://pkg.go.dev/github.com/ncruces/go-sqlite3/ext/stateme... Mine is a strict port, though admittedly, this could be improved with additional pushdown.