SQL pipe syntax available in public preview in BigQuery

Re:SQL pipe syntax available in public preview in BigQuery by benrutter on Thursday February 13, 2025 @10:06AM (#43036570)

I love the design behind PRQL, was a little dissapointed when I tried using it with an MSSQL server and found there was no decent way to filter for `LIKE '%something%'`.

(PRQL uses regex for stuff like this, which sounds great but then isn't supported on some databases like MSSQL)

[ Parent | on HN ]

Re:SQL pipe syntax available in public preview in BigQuery by default-kramer on Thursday February 13, 2025 @10:42AM (#43036988)

I'm very surprised to learn that PRQL does not natively support `like`, but you can add it yourself: https://github.com/PRQL/prql/issues/1123#issuecomment-135385...

[ Parent | on HN ]

Re:SQL pipe syntax available in public preview in BigQuery by promiseofbeans on Thursday February 13, 2025 @12:11PM (#43038373)

Huh, it's super cool they have a built-in way of extending to support missing engine features!

[ Parent | on HN ]

Re:SQL pipe syntax available in public preview in BigQuery by benrutter on Friday February 14, 2025 @09:44AM (#43048838)

Oh man that's awesome!

[ Parent | on HN ]