{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT COUNT(*)\n        FROM roles r\n        WHERE r.audience = 'EXTERNAL'\n          AND ($1 = '' OR LOWER(r.name) LIKE '%' || $1 || '%' OR LOWER(r.key) LIKE '%' || $1 || '%')\n          AND ($2 = '' OR (CASE WHEN $2 = 'ACTIVE' THEN r.is_active ELSE NOT r.is_active END))\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "count",
        "type_info": "Int8"
      }
    ],
    "parameters": {
      "Left": [
        "Text",
        "Text"
      ]
    },
    "nullable": [
      null
    ]
  },
  "hash": "fbe3eb70cdf7f09efb931d6f68d985ae64c9f1f02de2ad742b0fb5c507a15f82"
}
