select UDF_F_NAME as "Employee First Name", UDF_L_NAME as "Employee Last Name" from JT_Employee

I'd rather not make it manual since there are somewhere in the ballpark of 200 UDF's and more adding each day. Is there no way to pull it out of a table in Sage?

Not to automatically be the column headers in your return set, no.  It's a limitation of SQL, and has nothing to do with Sage 100.  The more user friendly names for UDF's are stored in the system table CM_UDF, and not in any kind of linkable meta-data that SQL can use for substituting as column names.  The SQL column names are what they are.

If it is critical, and you want to spend hours and hours building T-SQL to query table structures and find a way to link in the CM_UDF data nicely... it might be technically possible, but certainly not done easily.

Even if I can export the data from CM_UDF, that would be fine because I can pair it up in Excel. But whenever I tried to find CM_UDF, it doesn't exist in the database list.

It is in MAS_System, not MAS_###.

Gotcha! I will ask for that data to be pulled. Thank you