Either you list all of the fields you want in the insert…select, or you use something else externally to build the list for you.
SQL does not have something like SELECT * except somefield FROM
, so you’ll have to bite the bullet and write out the field names.