A parameter inside the quoted value like that doesn't look right. I haven't used this API... but I have used many analogous ones.
Try a test like this:
SELECT * FROM products WHERE name LIKE '%' || :productName || '%'
That's a more typical way to reference your parameter.
IAM Authentication to RDS Aurora Serverless PostgreSQL Proxy (Non-Public)asked 13 days ago
Use PostgreSQL LIKE % wildcards with RDS Data API?Accepted Answerasked 9 months ago
table creation on serverless deployment - RDS Aurora PostgreSQLasked a month ago
Connecting to Aurora PostgreSQL serverless v2 from lambdaasked 3 months ago
Tracking changes in data in Aurora PostgreSQLAccepted Answerasked 3 years ago
AWS RDS Aurora PostgreSQL Serverless: boto3: RETURNING CLAUSEasked a year ago
Does RDS/Aurora for postgresql support cron.task_running_timeoutasked 2 months ago
Migrating RDS PostgreSQL to Aurora PostgreSQL in a different accountAccepted AnswerEXPERTasked 2 years ago
Choosing RDS PostgreSQL over Aurora PostgreSQLasked 6 months ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago