Introspection of MySQL views

[pimeys]

We should fit this beauty to the SQL describer:

select col.table_schema as database_name,
       col.table_name as view_name,
       col.ordinal_position,
       col.column_name,
       col.data_type,
       case when col.character_maximum_length is not null
            then col.character_maximum_length
            else col.numeric_precision end as max_length,
       col.is_nullable
from information_schema.columns col
join information_schema.views vie on vie.table_schema = col.table_schema
                                  and vie.table_name = col.table_name
where col.table_schema not in ('sys','information_schema',
                               'mysql', 'performance_schema')
    -- and vie.table_schema = 'database_name' -- put your database name here
order by col.table_schema,
         col.table_name,
         col.ordinal_position;

There can be relations between views, or models and views. These are not based on foreign keys. They should be kept in re-introspection, for now.

Part of: #17412