title: Postgresql: More than 100 parameters for execute format query
body: <p>I am executing a SQL query using execute format which requires multiple number of variables to be passed as a parameter. Over here my query needs lot of symbols such as : <code>'%' and ','</code></p>
  
  <p>Hence my query has been so big that it is exceeding the limit of 100 parameters. So is there a way to include <code>'%' and ','</code> in the query itself rather than passing it as a parameter.</p>
  
  <p>Query:</p>
  
  <pre><code> execute format('CREATE MATERIALIZED VIEW %I AS 
          SELECT id,
                 (select count(*) from friends bob where (i.name ilike any (string_to_array(replace( concat(%L,bob.keywords,%L),%L,%L),%L)) or 
  i.description ilike any (string_to_array(replace( concat(%L,bob.keywords,%L),%L,%L),%L)) or
   i.additional_info ilike any (string_to_array(replace( concat(%L,bob.keywords,%L),%L,%L),%L)) or 
  i.eventful_category ilike any (string_to_array(replace( concat(%L,bob.keywords,%L),%L,%L),%L)) or
   i.other_category ilike any (string_to_array(replace( concat(%L,bob.keywords,%L),%L,%L),%L)) )) as friend_bob
  from events i ','FrienView','%','%',',','%,%',',','%','%',',','%,%',',','%','%',',','%,%',',','%','%',',','%,%',',','%','%',',','%,%',',')
  </code></pre>