Custom Query with `:` in text fails to save!

[nshkrsh]

Wappler 5.4.0
PG SQL 13
Node.JS 14

in a custom query, have some text that has : inside it.
INSERT INTO tbl (one, two) VALUES (:P1, 'some :text :with :colons');
have obv added :P1 param in the params list.

getting following error when trying to save this custom query:

this is not right, should be allowed to save hard coded text with : inside.

[Teodor]

Can you please paste the exact use case/sql code using : ?

[nshkrsh]

@nshkrsh

INSERT INTO tbl (one, two) VALUES (:P1, 'some :text :with :colons');

yes, i mentioned a sample query that gives error shown in screenshot above.

[nshkrsh]

:P1 is the actual variable here. the 2nd value is just raw text, not a variable - but becuase there are : in it, it’s treated as variable by Wappler logic and hence does not allow to save the custom query.

[Teodor]

I just tested this with a nodejs project and db locally. It works fine here:

You can close/save the window, test the query and run it. I see the values inserted:

Are you sure you created :P1 in the parameters list and assigned an expression to it?