SNOW-760624: func.now() should be rendered as CURRENT_TIMESTAMP

[sjhewitt]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

   Python

2. What operating system and processor architecture are you using?

   macOS-13.2-x86_64-i386-64bit

3. What are the component versions in the environment (pip freeze)?

asn1crypto==1.5.1
attrs==22.2.0
certifi==2022.12.7
cffi==1.15.1
charset-normalizer==2.1.1
cryptography==39.0.2
Cython==0.29.33
filelock==3.9.1
greenlet==2.0.2
idna==3.4
iniconfig==2.0.0
numpy==1.24.2
oscrypto==1.3.0
packaging==23.0
pandas==1.5.3
pluggy==1.0.0
pycparser==2.21
pycryptodomex==3.17
PyJWT==2.6.0
pyOpenSSL==23.0.0
pytest==7.2.2
python-dateutil==2.8.2
pytz==2022.7.1
requests==2.28.2
six==1.16.0
snowflake-connector-python==3.0.1
snowflake-sqlalchemy @ file:///.../dist/snowflake_sqlalchemy-1.4.7-py2.py3-none-any.whl
SQLAlchemy==1.4.46
typing_extensions==4.5.0
urllib3==1.26.15

4. What did you do?

session.execute(select(func.now())

5. What did you expect to see?

expected:

SELECT CURRENT_TIMESTAMP AS now_1

actual:

SELECT now()

6. Can you set logging to DEBUG and collect the logs?