feat(sink): support create sink as query#6648

mergify[bot] merged 16 commits intomainrisingwavelabs/risingwave:mainfrom

yuhao/create_sink_asrisingwavelabs/risingwave:yuhao/create_sink_asCopy head branch name to clipboard