code: def _partition_query(
              cls, table_name, limit=0, order_by=None, filters=None):
          
          limit_clause = 'LIMIT {}'.format(limit) if limit else ''
          order_by_clause = ''
          if order_by:
              l = []  # noqa: E741
              for field, desc in order_by:
                  l.append(field + ' DESC' if desc else '')
              order_by_clause = 'ORDER BY ' + ', '.join(l)
  
          where_clause = ''
          if filters:
              l = []  # noqa: E741
              for field, value in filters.items():
                  l.append(f"{field} = '{value}'")
              where_clause = 'WHERE ' + ' AND '.join(l)
  
          sql = textwrap.dedent(f"""\
              SELECT * FROM "{table_name}$partitions"
  
              {where_clause}
              {order_by_clause}
              {limit_clause}
          """)
          return sql
docs: Returns a partition query
  
          :param table_name: the name of the table to get partitions from
          :type table_name: str
          :param limit: the number of partitions to be returned
          :type limit: int
          :param order_by: a list of tuples of field name and a boolean
              that determines if that field should be sorted in descending
              order
          :type order_by: list of (str, bool) tuples
          :param filters: dict of field name and filter value combinations