CrudKit\Data\SQLDataProvider::getData PHP Method

    public function getData(array $params = array())
    {
        $skip = isset($params['skip']) ? $params['skip'] : 0;
        $take = isset($params['take']) ? $params['take'] : 10;
        $builder = $this->conn->createQueryBuilder();
        $builder->select($this->queryColumns('all', array(), 'exprAs', false, true))->from($this->tableName)->setFirstResult($skip)->setMaxResults($take);
        if (isset($params['filters_json'])) {
            $filters = json_decode($params['filters_json'], true);
            if (count($filters) > 0) {
                $this->addConditionsToBuilder($builder, $filters);
            }
        }
        LoggingHelper::logBuilder($builder);
        $exec = $builder->execute();
        return $exec->fetchAll(\PDO::FETCH_ASSOC);
    }