Hi Ramin, Thanks for the Flip. In the text you say EXECUTE STATEMENT SET BEGIN INSERT INTO `sales` SELECT ...; INSERT INTO `products` SELECT ...; END;
Twice, I think you are intending the 2nd text to be different. Maybe EXPLAIN STATEMENT SET I am worried that in the SQL standard EXECUTE and EXPLAIN are at the same level when SQL parsing – so it would not be compliant SQL to allow EXPLAIN EXECUTE. Is there precedence for this in another implementation / SQL reference? Kind regards, David. From: Ramin Gharib <rgha...@confluent.io> on behalf of Ramin Gharib <rgha...@confluent.io.INVALID> Date: Monday, 28 April 2025 at 12:04 To: dev@flink.apache.org <dev@flink.apache.org> Subject: [EXTERNAL] [DISCUSS] FLIP-527 Support EXPLAIN EXECUTE STATEMENT SET Syntax in Flink SQL Hi Flink Community, I want to discuss FLIP-527: Support EXPLAIN EXECUTE STATEMENT SET Syntax in Flink SQL. This FLIP proposes to extend the EXPLAIN statement in Flink SQL to support the EXECUTE STATEMENT SET syntax. The goal is to provide users with a way to understand the execution plan of a batch of SQL statements before they are executed together. This will enhance debugging, optimization, and overall understanding of how Flink processes a series of dependent operations. You can find the full proposal details on the Flink Wiki at: https://cwiki.apache.org/confluence/display/FLINK/FLIP-527%3A+Support+%60EXPLAIN+EXECUTE+STATEMENT+SET%60+Syntax+in+Flink+SQL I'm eager to hear your thoughts, feedback, and potential concerns regarding this proposal. Thanks, Ramin Gharib [image: Confluent] <https://www.confluent.io> *Ramin Gharib *he/him/his Senior Software Engineer *Follow us: *[image: Blog] <https://www.confluent.io/blog?utm_source=footer&utm_medium=email&utm_campaign=ch.email-signature_type.community_content.blog>[image: Twitter] <https://twitter.com/ConfluentInc>[image: LinkedIn] <https://www.linkedin.com/company/confluent/>[image: Slack] <https://slackpass.io/confluentcommunity>[image: YouTube] <https://youtube.com/confluent> [image: Try Confluent Cloud for Free] <https://www.confluent.io/get-started?utm_campaign=tm.fm-apac_cd.inbound&utm_source=gmail&utm_medium=organic> Sent with Notion Mail <https://www.notion.so/product/mail> Unless otherwise stated above: IBM United Kingdom Limited Registered in England and Wales with number 741598 Registered office: Building C, IBM Hursley Office, Hursley Park Road, Winchester, Hampshire SO21 2JN
