Double ' && ' in JavaScript FUNCTIONs are converted to single ' & ' breaking the logic

[simonepm]

SnowCLI version

3.3.0

Python version

3.11

Platform

Win11

What happened

Hello, please,

we notice a bug while creating a FUNCTION via snow sql --filename function_creation_statement.sql

All the occurrences of ' && ' are applied as ' & ' instead, breaking the JavaScript logic inside the CREATE FUNCTION $$ ... $$ statements.

Thanks!

How to reproduce

1. Create a function_creation_statement.sql file with the following content:

CREATE FUNCTION TEST_AMPERSAND() RETURNS BOOLEAN LANGUAGE JAVASCRIPT AS $$
  return true && false;
$$;

2. Run: snow sql --filename function_creation_statement.sql

3. Execute: SELECT GET_DDL('FUNCTION', 'TEST_AMPERSAND');

CREATE FUNCTION TEST_AMPERSAND() RETURNS BOOLEAN LANGUAGE JAVASCRIPT AS $$
  return true & false;
$$;