SQLite database support
We've looked into it before as I agree, it'd be awesome. But as of February 2020, the answer is no because SQLite is missing some key features that Craft currently relies on: https://www.sqlite.org/omitted.html

Specifically the missing joins and alter table commands.