Migrate `SHOW MODELS` query to use the information schema with `UNION ALL`

This will allow us to provide more information than `Model Name`

https://docs.confluent.io/cloud/current/flink/reference/flink-sql-information-schema.html#models