def find(self, *_clauses, **kwargs):
        _limit = kwargs.pop('_limit', None)
        _offset = kwargs.pop('_offset', 0)
        _step = kwargs.pop('_step', 5000)
        order_by = kwargs.pop('order_by', 'id')
        return_count = kwargs.pop('return_count', False)
        return_query = kwargs.pop('return_query', False)
        _filter = kwargs

        self._check_dropped()
        if not isinstance(order_by, (list, tuple)):
            order_by = [order_by]
        order_by = [o for o in order_by if (o.startswith('-') and o[1:] or o) in self.table.columns]
        order_by = [self._args_to_order_by(o) for o in order_by]

        args = self._args_to_clause(_filter, ensure=False, clauses=_clauses)

        # query total number of rows first
        count_query = alias(self.table.select(whereclause=args, limit=_limit, offset=_offset),
                            name='count_query_alias').count()
        rp = self.database.executable.execute(count_query)
        total_row_count = rp.fetchone()[0]
        if return_count:
            return total_row_count

        if _limit is None:
            _limit = total_row_count

        if _step is None or _step is False or _step == 0:
            _step = total_row_count

        query = self.table.select(whereclause=args, limit=_limit,
                                  offset=_offset, order_by=order_by)
        if return_query:
            return query
        return ResultIter(self.database.executable.execute(query),
                          row_type=self.database.row_type, step=_step)
Perform a simple search on the table.
dataset/ETHPy150Open pudo/dataset/dataset/persistence/table.py/Table.find