Itgenclr121 Must declare the scalar variable "@w1E"

Questions
,
1

When executing the following query on 22.0.602:

select listagg([E-Mail], chr(13))
from   MY_PROD.dbo.[MY PROD$Element]
where  [E-Mail] is not null 
and    length([E-Mail]) > 0
and [E-Mail] like '%@acme.com'

I receive the following error:

itgenclr121
External error in Invantive Data Hub.
Incorrect syntax near ‘-’.
Must declare the scalar variable “@w1E”.

How can I run such a filtered query on a SQL Server table with a column named “E-Mail” (case sensitive, with a dash)?

2

This has been fixed in releases 22.0.628 and later:

select listagg([E-Mail], chr(13))
from   GermanTable
where  [E-Mail] is not null 
and    length([E-Mail]) > 0
and [E-Mail] like '%@acme.com'