laravel-pdo-odbc icon indicating copy to clipboard operation
laravel-pdo-odbc copied to clipboard

Use of SQL functions

Open nzscripps opened this issue 2 years ago • 2 comments

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?

nzscripps avatar Jan 20 '23 19:01 nzscripps