Support convert new SqlNode to physical plan

new sql syntax was added
- #445
- #455
- #443
- #447

currently only logical plan is supported.
It might necessary to convert some of those into physical plan e.g #445 , for the use in online mode

Review the linked PRs (#445, #455, #443, #447) to understand the new SQL syntax added. Examine the logical plan implementation and identify the components needing conversion to a physical plan, especially for online mode. Look for existing physical plan conversion code as a reference. Determine the specific SQL nodes from the PRs that require this conversion and the expected output.

Written by the indexing model from the issue text.