# in column name

[otelconsulting]

Working with an exsisting DB structure and they have # special char all over their column names in a DB2 database.

Using
->orderBy( 'A.G01GL#' )

results in the sql statement being

ORDER BY
"A"."G01GL"# ASC

Any advice on how to get around this?

[otelconsulting]

problem is in function replaceNamesIn

[otelconsulting]

Modifying the regex in replaceNamesIn to /(\b)([a-z_][a-z0-9_]).([a-z#][a-z0-9#])/i solved it for me.