[FLINK-25600] Support new statement set syntax in sql client and update docs

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / API, Table SQL / Client
• Labels: pull-request-available
• Assignee: Wenlong Lyu
• Reporter: Wenlong Lyu
• Created: 11/Jan/22 02:34
• Updated: 18/Feb/22 14:03
• Resolved: 18/Feb/22 14:03

Description

this is a follow up of FLINK-25392, to finish adding the new statement set:
1. the new statement set need multi line parsing support in sql client, which is not supported currently:
execute statement set begin
insert xxx;
insert xxx;
end;
2. we need to update the doc to introduce the new syntax

Issue Links

• relates to: FLINK-25392 Add new STATEMENT SET syntax
• links to: GitHub Pull Request #18363