Meanwhile SOQL has learned new tricks:
SELECT FIELDS(ALL) FROM myTableName
This selects every field - custom and standard fields of myTableName. FIELDS(Custom) and FIELDS(Standard) work as the name suggests.
FIELDS(Custom)
FIELDS(Standard)