hugsql 2020-05-15

So im looking for an example to be able to dynamically write a postgres query like this

select * from user_profiles up where up.data->'contactInfo'->>'name' ilike '%nombre%'