SQL auto-generates select list of fields for primary select

I would search for this, but I have no idea of the search terms. I vaguely
recall a relatively new SQL function that could auto-generate a list of
fields that could be used in a select statement. So, for example,

SELECT *magiclistoffields* from ABCTABLE

*magiclistoffields* is a result of another select (lateral???) that you can
exclude certain fields from the list. If ABCTABLE has fields FLD1, FLD2,
FLD3, and FLD4, I would like to select only fields FLD3 and FLD4, so that
the above select example is rendered as

SELECT FLD3, FLD4 from ABCTABLE

FWIW, I'm on v7r1 with somewhat recent TRs.

Pipe dream or reality?

- Dan