[Feature]: Provide standard SQL management instructions and command-line tools

[zhoujinsong]

Description

Currently, different management instructions are provided for different table formats in different engines. In order to provide a plug-and-play data lake experience, we need to provide a set of standard and unified management instructions and their corresponding command-line tools.

Use case/motivation

Provide standard SQL management instructions and command-line tools so that users can use it to manage all data lake tables with unified commands.

Describe the solution

• Provide standard SQL access methods, such as MySQL protocol.
• Provide a set of standard table management statements, including viewing, creating, modifying, and deleting tables.
• Provide a set of standard monitoring commands to view various states of the table.

Subtasks

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[shendanfengg]

For standard SQL, we need to support the "SHOW CREATE TABLE" syntax, which is not yet supported in version 041.

[baiyangtx]

For standard SQL, we need to support the "SHOW CREATE TABLE" syntax, which is not yet supported in version 041.

Why do we need SQL like this? The standard SQL maybe not a spark sql and not run in spark engine.

[Kyofin]

I would like to understand if the target scenario involves enabling users to access Amoro through a CLI tool and use SQL-like syntax to operate on Amoro tables within this CLI tool.

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.