Endatabas
simonwillison.net/2024/Mar/1/endatabas
What Jamie wrote
I hadn't heard of Endatabas and this summary from Willison hits on some great highlights.
It uses a variant of SQL which allows you to insert data into tables that don’t exist yet (they’ll be created automatically) then run standard select queries, joins etc. It maintains a full history of every record and supports the recent SQL standard “FOR SYSTEM_TIME AS OF” clause for retrieving historical records as they existed at a specified time (it defaults to the most recent versions).
Pretty cool stuff.