Consider using views for some information schema tables

[JanJakes]

This would likely enable us to support some dynamic values (like auto-increment) in the information schema tables.

From MySQL 8, all the information schema tables are views on fewer virtual and invisible system tables under the mysql database (mysql.tables, etc.), which hints that maybe we could store this info in fewer, more universal tables and then just create views, which could also read some info from other tables like sqlite_master and other ones.