Source
SnowConvert AI - Redshift - Conditions
A BETWEEN condition tests expressions for inclusion in a range of values, using the keywords BETWEEN and AND.
SnowConvert AI - SQL Server-Azure Synapse - SELECT
SELECT Translation reference for SELECT statement inside procedures in Transact - SQL.