Expand memory connector functionality

[mosabua]

The memory connector is the fastest operating and easiest to use connector for catalogs. Unfortunately it currently does not support many SQL features of Trino and therefore can not be used for testing and other usage.

This issue aims to collect the tasks to expand the functionality of the connector. These features do not necessarily have to be suitable for productions usage or even usable for clusters with multiple workers in terms of data consistency. They can potentially just be suitable for testing or limited scenario usage. We just have to get started and can then expand in terms of robustness. Each update should include relevant doc change.

Docs for the memory connector are at https://trino.io/docs/current/connector/memory.html

Specifically SQL support - https://trino.io/docs/current/connector/memory.html#sql-support

Following are items to implement:

• Update
• Delete
• Truncate Add support for TRUNCATE statement in memory connector #22337
• Merge
• Alter table
  • Add support for renaming columns in Memory connector #22607
  • Add support for not null constraint in Memory connector #22601
  • Add support for adding new columns in Memory connector #22610
  • Add support for dropping columns in Memory #22657
• Alter schema Add support for renaming schemas in Memory #22659
• View management
• Materialized view management

[dcsena]

+1 for Update/Delete support