Should WordPress ship with Sqlite by default, you can replace with MySQL as needed?
Should WordPress ship with Sqlite by default, you can replace with MySQL as needed?
No. Not until it's a first-class citizen with a proper abstraction layer, works with WP-CLI, and plugins can express support. But probably never. Otherwise a huge mess of user experience will follow.
As someone who uses SQLite in development and static site builds I would love to see parity most of the WP-CLI issues are around the use of mysql tooling and could be improved fairly easily. What can't is the large amount of plugins with non wpdb calls or making use of MySQL specific functions