[DONTMERGE] Refine experimental SQL template based on multi-statement support

[lennartkats-db]

Changes

This PR refines the experimental SQL template based on (the upcoming) multi-statement support.

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 53.80%. Comparing base (e22dd8a) to head (483e26f). Report is 8 commits behind head on main.

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #1289      +/-   ##
==========================================
+ Coverage   52.25%   53.80%   +1.55%     
==========================================
  Files         317      322       +5     
  Lines       18004    14570    -3434     
==========================================
- Hits         9408     7840    -1568     
+ Misses       7903     6002    -1901     
- Partials      693      728      +35     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[pietern]

@lennartkats-db What is the (rough) ETA for this?

[lennartkats-db]

@lennartkats-db What is the (rough) ETA for this?

This should land somewhere within the next few weeks.

[lennartkats-db]

Closing in favor of https://github.com/databricks/cli/pull/1463.