docs: def _get_table_infos(
              self,
              trimmed=False):
          """query the sherlock-catalogues database table metadata
          """
          self.log.debug('starting the ``_get_table_infos`` method')
  
          sqlQuery = u"""
              SELECT * FROM crossmatch_catalogues.tcs_helper_catalogue_tables_info where legacy_table = 0 and table_name not like "legacy%%" and table_name not like "%%stream"  order by number_of_rows desc;
          """ % locals()
          tableInfo = readquery(
              log=self.log,
              sqlQuery=sqlQuery,
              dbConn=self.cataloguesDbConn,
              quiet=False
          )
  
          if trimmed:
              cleanTable = []
              for r in tableInfo:
                  orow = collections.OrderedDict(sorted({}.items()))
                  for c in self.basicColumns:
                      if c in r:
                          orow[c] = r[c]
                  cleanTable.append(orow)
              tableInfo = cleanTable
  
          self.log.debug('completed the ``_get_table_infos`` method')
          return tableInfo