https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/39878#M27085 <P>Python often edges out SQL with its metaprogramming capabilities. However, <STRONG>dbt</STRONG> bridges this gap with Jinja templates. Introducing simple "for" loops, especially for parameter iteration, in <STRONG>databricks</STRONG> SQL could significantly enhance the user experience.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ezgif-5-0f8c73663b.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3127i04DC3D6A467B755E/image-size/large?v=v2&amp;px=999" role="button" title="ezgif-5-0f8c73663b.gif" alt="ezgif-5-0f8c73663b.gif" /></span></P> Mon, 14 Aug 2023 19:07:19 GMT Hubert-Dudek 2023-08-14T19:07:19Z https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/39878#M27085 <P>Python often edges out SQL with its metaprogramming capabilities. However, <STRONG>dbt</STRONG> bridges this gap with Jinja templates. Introducing simple "for" loops, especially for parameter iteration, in <STRONG>databricks</STRONG> SQL could significantly enhance the user experience.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ezgif-5-0f8c73663b.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3127i04DC3D6A467B755E/image-size/large?v=v2&amp;px=999" role="button" title="ezgif-5-0f8c73663b.gif" alt="ezgif-5-0f8c73663b.gif" /></span></P> Mon, 14 Aug 2023 19:07:19 GMT https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/39878#M27085 Hubert-Dudek 2023-08-14T19:07:19Z https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/41186#M27310 <P>Thanks for the feedback, we have raised an Internal Idea request&nbsp; for this suggestion. Based on the need of the customers this will be prioritized and added to the roadmap in the future.</P><P>Meanwhile you can alos refer our query&nbsp; parameters&nbsp; section for your reference <A href="https://docs.databricks.com/en/sql/user/queries/query-parameters.html" target="_blank">https://docs.databricks.com/en/sql/user/queries/query-parameters.html</A></P> Wed, 23 Aug 2023 16:10:10 GMT https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/41186#M27310 Rajeev45 2023-08-23T16:10:10Z https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/106322#M42449 <P>Was this solved <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/38009">@Rajeev45</a>&nbsp;&nbsp;Do you have any docs?</P> Mon, 20 Jan 2025 13:39:10 GMT https://community.databricks.com/t5/data-engineering/bridging-the-sql-python-gap/m-p/106322#M42449 Greg_c 2025-01-20T13:39:10Z