modelo = "(?=.*TEXTO_A_BUSCAR.*)"
select * from vehicle where marca ilike :marca and upper (modelo) ~ :modelo

select id, name, search_for_type from table,
                          jsonb_to_recordset(table.campojson) as items(name text,
                          search_for_type text)
where name='Data Lookup'