berkaysynnada opened a new issue, #14512:
URL: https://github.com/apache/datafusion/issues/14512
### Is your feature request related to a problem or challenge?
People may need to write flexible SQL queries that adapt to different table
schemas without hardcoding column names.
Query reusability is very limited currently, and creating dynamic queries
requires external templating. A built-in mechanism to define and use dynamic
SQL macros would significantly enhance the expressiveness and reusability
### Describe the solution you'd like
Introduce support for dynamic SQL macros that allow users to parameterize
column selection. For example, a macro could accept lists of columns to include
or exclude and then automatically select the appropriate columns from a given
table or CTE. An example usage might look like this:
```sql
CREATE OR REPLACE MACRO dynamic_select(
include_cols,
exclude_cols
) AS TABLE (
FROM source_table
SELECT
COLUMNS(col ->
(list_contains(include_cols, col))
AND
(NOT list_contains(exclude_cols, col))
)
);
WITH source_table AS (
SELECT * FROM employees
)
FROM dynamic_select(
['id', 'name', 'department'],
['salary']
);
```
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
