Clickhouse string ordering and string filtering by UTF8 instead of bytes

[casab]

Clickhouse defaults to using bytes to order by and string manipulation functions such as lower, upper uses ascii. To overcome this limitation they have COLLATE keyword, and lowerUTF8, upperUTF8 functions.

Check List

• [X] Tests has been run in packages where changes made if available
• [X] Linter has been run for changed code
• [ ] Tests for the changes have been added if not covered yet
• [X] Docs have been added / updated if required

Description of Changes Made (if issue reference is not provided)

• Replaced CONCAT SQL function with js template literal to prevent unnecessary DB function call
• Used lowerUTF8 instead of lower to support utf8 compatible search
• Added COLLATE ‘en’ when ordering by strings to order incasesensitive. Clickhouse orders by bytes on default.