Dynamic SQL feature in Dremio

Does Dremio have the feature to run Dynamic SQLs ? An example scenario is this - appending columns dynamically for each day.

@xabraham If your base dataset has new columns added then Dremio should learn them, but if your SQL is not select * and should add columns in the text that is not possible