Added Virtual Columns to system.tables Table

Why it matters

This feature provides users with enhanced metadata visibility by exposing the full CREATE TABLE query, the complete engine description, and the metadata modification timestamp directly within the system.tables table. It helps users to easily inspect table definitions and metadata changes without extra queries or file access.

How to use it

Users can query the newly added virtual columns directly from the system.tables table in SQL. For example, use:

SELECT name, create_table_query, engine_full, metadata_modification_time
FROM system.tables
WHERE database = 'your_database'

This will show the table schema creation query, engine details, and metadata modification time for each table.