Bubble SQL Connector parameters

Can someone point me to some documentation on the proper syntax for including parameters to SQL?

I’m running postgresql

Here is a very simple SQL queries that are not performing as expected.


However, this seems to work fine

I don’t understand how parameters are being added to the SQL query. Please advise

I didn’t check to confirm your syntax is correct re: enum_range(NULL::$1) but I assume you did. However you can reference this post: SQL Connector SQL Server Parameter Format
And this one: SQL Database Connector connection issues - #14 by wwweb2401

For postgres the $1 syntax is correct however there are limitations in the syntax (per the second post) where legal syntax is disallowed by the Bubble’s SQL DB connector.

This is the reason we created our SQL Pro plugin to support standard SQL syntax.