[SPARK-46246] Support EXECUTE IMMEDIATE sytax in Spark SQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 4.0.0
• Component/s: Spark Core
• Labels: pull-request-available
• Assignee: Milan Stefanovic
• Reporter: Milan Stefanovic
• Created: 04/Dec/23 15:51
• Updated: 19/Dec/23 16:04
• Resolved: 19/Dec/23 16:04

Description

Introducing new EXECUTE IMMEDIATE syntax to support parameterized queries from within SQL.

This API executes query passed as string with arguments.

Other DBs that support this:

• Oracle
• Snowflake
• PgSql

Issue Links

• links to: GitHub Pull Request #44093