`information_schema.tables` missing `last_altered` column

[DanCardin]

I eluded to this issue in https://github.com/tekumara/fakesnow/pull/122#issuecomment-2267340187, but not all of duckdb's exactly match snowflakes.

Now, at least, I actually have a concrete location in which it negatively affects my ability to test 😆, i.e. information_schema.tables's missing last_altered column.

My first thoughts would be:

• I assume we can't mutate the duckdb information_schema
• if this is something you want to support fixing, I could attempt creating a _fs_information_schema with at least a view pointing at the original with the missing column
  • Seems impractical to actually support the semantics behind, for example, that column(?)
• Search every query for table references and swap any that point at information_schema to the new schema?
  • or perhaps just .tables in the short term, since it would otherwise require stubs for every information_schema table, not sure off the top of my head how many there are

[tekumara]

Yes that makes sense and follows the exisiting pattern 😊

[tekumara]

BTW 7581212f31a4ef46f2a067493626f3c940b72584 introduced a _FS_INFORMATION_SCHEMA

[Genora51]

FWIW we're also missing row_count; would be amazing to get these columns added somehow, even if they're just stubs