Support mainstream database metadata table query

[chakkk309]

This is one of the potential features which proposed for GSoC 2023 program, and the detail content ref to here (GSOC-165).

Background

ShardingSphere has designed its own metadata database to simulate metadata queries that support various databases.

More details:

ref to #21268 and #22052

Warmup Tasks

• Support query for MySQL metadata parameters
• Support query for MySQL metadata routines
• Support query for MySQL metadata accounts

ref to #24378

Sub Tasks

• Support PostgreSQL And openGauss \d tableName
• Support PostgreSQL And openGauss \d+
• Support PostgreSQL And openGauss \d+ tableName
• Support PostgreSQL And openGauss l
• Support query for MySQL metadata TABLES
• Support query for MySQL metadata COLUMNS
• Support query for MySQL metadata schemata
• Support query for MySQL metadata ENGINES
• Support query for MySQL metadata FILES
• Support query for MySQL metadata VIEWS

[chakkk309]

@tuichenchuxin, please assign to me, many thanks.

[strongduanmu]

@chakkk309 Assigned.