SQLite Forum

SQLite3 Extension
Login
> …move beyond simple SELECT and INSERT statements mixed with a pile of procedural code and instead write complex queries that give the answer directly…

drh wrote of the talks he's been giving about this topic, the most recent of which — that I'm aware of — is his "[2020 SQLite Status Update][0]" from 3 weeks ago. That link takes you into the middle of the talk where he begins his discussion of [a sequence of slides][1] that eventually takes you to [a very complicated query][2] which makes use of an application-defined SQLite function: Fossil's `files_of_checkin()` table-valued function, called right up at the top.

drh is not advocating that all possible functions be built into SQLite.

[0]: https://youtu.be/vfAOvyI9Kuw?t=2069
[1]: https://sqlite.org/st2020/slide21.html
[2]: https://sqlite.org/st2020/slide22.html