Text fields with autocomplete only expects one column to be returned from the query, making the following an impossible selection.

because APEX does not allow definition of single column queries in Shared Components -> LOVs (as of 18.2)

This means we must use 'SQL Query' for the SQL definition.
Is there something in the pipeline to address this?