'Executes a SELECT query on the named table, which may return zero or
more rows, returning the result as a list of dicts.
Args:
txn : Transaction object
table (str): the table name
term (str | None):
term for searching the table matched to a column.
col (str): column to query term should be matched to
retcols (iterable[str]): the names of the columns to return
Returns:
defer.Deferred: resolves to list[dict[str, Any]] or None'

@classmethod
def _simple_search_list_txn(cls, txn, table, term, col, retcols):

    if term:
        sql = ('SELECT    %s    FROM    %s    WHERE    %s    LIKE    ?' % (',    '.join(retcols), table, col))
        termvalues = [(('%%' + term) + '%%')]
        txn.execute(sql, termvalues)
    else:
        return 0
    return cls.cursor_to_dict(txn)
