Expanding select star ("SELECT *" to "SELECT col1, col2 ...")

[prabhur]

I'm looking for some help on ideas to expand "*" in the Select expression, perhaps referencing a schema argument, and replacing it with list of columns.

I remember stumbling on a question that asked about this problem (I think) citing a link to one of the blog posts of select.dev. However, I can't find it in the discussions.

Thanks in advance.

[tobymao]

check out the optimizer here

https://github.com/tobymao/sqlglot/blob/main/sqlglot/optimizer/qualify.py