Bridging the SQL-Python Gap

[Hubert-Dudek]

Python often edges out SQL with its metaprogramming capabilities. However, dbt bridges this gap with Jinja templates. Introducing simple "for" loops, especially for parameter iteration, in databricks SQL could significantly enhance the user experience.

[Rajeev45]

Thanks for the feedback, we have raised an Internal Idea request  for this suggestion. Based on the need of the customers this will be prioritized and added to the roadmap in the future.

Meanwhile you can alos refer our query  parameters  section for your reference https://docs.databricks.com/en/sql/user/queries/query-parameters.html