With the Oracle dialect, when selecting a column alias from a deeply nested subquery, where the alias is longer than 24 characters, the alias in the outside select is truncated to 24 characters and ...