可以使用DolphinDB元编程来实现,元编程教程链接:https://gitee.com/dolphindb/Tutorials_CN/blob/master/meta_programming.md
上述场景的具体例子如下
colNames = t.schema().colDefs.name //假设不取col1、col2 select_cols = colNames[at(!(colNames in [`col1, `col2]))] res = sql(sqlCol(select_cols), t).eval()
查看返回的结果res变量的内容如下