support prepared statements for DDL

[BugenZhao]

There were no technical issues blocking this. Recently we found some users requesting this feature.

Most of work have done. Remain work: create as with parameter, create view with parameter, create sink with parameter.

But I don't think it's worth to support them beacase:

Can't support ddl with param like create view v as
Actually I think it's not necessary because the param is useful for reusing a sql. But for ddl sql, it can't be reused because you can't create a view or table twice. So I think the user may rarely use ddl with param. And if we support it, it will cause the redundant and duplicate code like query handle so that it take effort to maintain or refactor them.

If this point is acceptable, this issue is done.

Originally posted by @ZENOTME in #8112 (comment)