feat: support show create dependency

[chenzl25]

Is your feature request related to a problem? Please describe.

Sometimes our users will give us a Create MV SQL to tell us that this SQL can't work, however, to reproduce this SQL in a different environment which needs all its dependencies.

So I suggest supporting a show statement to show all its dependencies.

show create dependency xxx

or

show create materialized view xxx cascade

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.