ClickHouse resolves identifiers to select-list aliases before table
columns by default, so lookup queries that reuse a column name as an
alias (e.g. 'data as metadata, 0 as data' in the item lookup) return
the alias literal instead of the column. Item lookups then return
metadata as UInt8 0, mixed lookup unions produce
Variant(Array(Int8), UInt8), and the JDBC client fails every /co
lookup with 'Column is not of array type'.
Setting prefer_column_name_to_alias=1 restores the alias semantics
these queries rely on under SQLite and MySQL.
Fixes#947