title: How to define 'with clause' with hardcoded values rather than a subquery?
body: <p>I have several combinations of values provided and need to build a query with them. It would seem a waste of time to define a subquery that would return those results. Instead, I'm thinking of defining a 'With Clause' that can use them. </p>
  
  <p>To make simple example, let's assume my query takes Country and City parameters. </p>
  
  <pre><code>WITH INPUT_DATA AS (
  'Canada' as COUNTRY
  ,'Toronto' as CITY
  ,'USA' as COUNTRY
  ,'Chicago' as CITY
  )
  SELECT * FROM SOME_TABLE WHERE COUNTRY=INPUT_DATA.COUNTRY AND CITY=INPUT_DATA.CITY
  </code></pre>
  
  <p>If there's another way to do this, outside of the 'with clause' and packages, please share, as well. Basically, I want to use some parameters for this query without having to code a subquery to fetch those parameters. Naturally, I need it to support multiple 'rows' of parameter sets. </p>
  
  <p>Please note: Where clause won't do. I can't put all these parameters in the 'where clause' and still have it legible. </p>