Is it possible to make a PGSQL query as a prepared statement using the LIKE keyword?

How do I do X?
1

This question was asked by one of our community members on Discord:

Can a PGSQL query be made as a prepared statement using the LIKE keyword?

2

Yes, it is possible. The below query in a PostgreSQL DB with Prepared Statement turned on and it works fine:

SELECT * FROM users WHERE email LIKE '{{Input1.text+"%"}}';