laravel-pdo-odbc
laravel-pdo-odbc copied to clipboard
Use of SQL functions
Using SQL functions is not working with this and using the Snowflake Native Driver. We have a number of queries like:
select *, case when run_code = 'Y' then 'Aired'
when run_code = 'N' and intended_air_date < current_date() then 'No Run'
when run_code = 'N' and intended_air_date >= current_date() then 'Scheduled'
else 'NA' end as Status
from MY_SNOWFLAKE_TABLE
The query is not parsed correctly. Simple queries like:
SELECT ID, NAME from MY_SNOWFLAKE_TABLE
Work fine. Any ideas as to why functions don't get parsed?