/**
* Select rows from a table.
*
* @param string $table The table(s) to query.
* @param mixed $fields The field (column) to query.
* @param mixed $where The where-clause.
* @param mixed $options The options (limit, offset etc.).
* @return function A lambda allowing you to access the found rows.
* @throws Dabble\Query\SelectException when no rows found.
* @throws Dabble\Query\SqlException on error.
*/
public function select($table, $fields, $where = [], $options = [])
{
if (is_scalar($fields)) {
$fields = explode(',', $fields);
}
$query = new Select($this, $table, $fields, new Where($where), new Options($options));
return $query->execute();
}
