Yes. But do they automagically create and maintain database indexes for the most common requests made by your webclients?

Should be doable. Applications only recently have a need for custom queries due to BI rising, so I guess DBs aren't yet there.

BTW IMO most of BI type stuff could be solved by just allowing direct SQL, but for this DBs would need to be written without buffer overflow bugs etc. I would love to have SQLite that has easy data-at-rest encryption amd that supports access control.

LiveView doesn’t allow arbitrary queries (or any queries really), so this is a non-issue.