---

SELECT
    table_schema,
    table_name
FROM information_schema.tables
WHERE table_schema IN ('dev', 'dev_local')
  AND (
       lower(table_name) LIKE '%query%'
    OR lower(table_name) LIKE '%model%'
  )
ORDER BY table_schema, table_name;