@@@ operator. @@@ takes a column on the left-hand side and a query builder function on the
right-hand side. It means “find all rows where the column matches the given query.”
For example:
SELECT description, rating, category
FROM mock_items
WHERE description @@@ pdb.regex('key.*rd');
Expected Response
description | rating | category
--------------------------+--------+-------------
Ergonomic metal keyboard | 4 | Electronics
Plastic Keyboard | 4 | Electronics
(2 rows)
description matches the regex expression key.*rd.