It is so frustrating when working with analytics/query and fields or columns are just missing.

Or have different names

well if they have different names I can at least can that from the records browser, but with advanced manufacturing specifically there are columns in tables that are just missing