3 ms·
Their first example doesn't look idiomatic at all: SELECT * FROM "users" WHERE like ("email", 'gmail') Should “like” here be a user-
by sinuhe69 3y ago
Their first example doesn't look idiomatic at all:
SELECT
*
FROM
"users"
WHERE
like ("email", 'gmail')
Should “like” here be a user-defined function? Because that’s not the syntax for SQL-like. To which SQL version will Pql translate its queries?
- hans_castorp 3y agoFurther down is an example using "minus (now (), toIntervalDay (1))" which is also non-standard SQL. I have no idea which DBMS they are targeting.
- shellcromancer 3y ago> The where operator will validate that the syntax is valid, but it will pass unknown function calls through to the underlying database. In RunReveal's case, we use Clickhouse under the hood, so if we wanted to do a case-insensitive match we could still use Clickhouse's lower function. From the release blog [1] they mention that unknown functions are passed through to the underlying SQL engine -- this let's them target anything from mysql, Postgres, ClickHouse or proprietary engines like Snowflake. 1. https://blog.runreveal.com/introducing-pql/ https://blog.runreveal.com/introducing-pql/