Do you mean something other than ISO/IEC 9075:2023 (the 9th edition of the SQL standard)?
- Sometimes the order doesn't matter - Sometimes there are functional dependencies - Sometimes one knows the length of the list in question is 1 (foreign key constraints)