---

SELECT
    query_model_id,
    name,
    substring(
        query
        FROM greatest(position('department_name' IN lower(query)) - 500, 1)
        FOR 1500
    ) AS fragment
FROM dev.query_model_query
WHERE lower(query) LIKE '%department_name%'
   OR (
        lower(query) LIKE '%ourpension.holding%'
        AND lower(query) LIKE '%holding_id%'
      )
ORDER BY query_model_id;