Top "Query-builder" questions

A query-builder is a set of classes and methods that is able to programmatically build queries.

How does group by works in sequelize?

I am looking for group by queries through Sequelize and cannot seem to find any documentation. SELECT column, count(column) …

javascript sql orm sequelize.js query-builder
doctrine 2 query builder and join tables

I'm trying to get all comments for each post in my home page return $this->createQueryBuilder('c') ->…

doctrine-orm left-join query-builder
Yii2: update field with query builder

How can I update field with query builder in Yii2? I can't find this in documentation. Thanks! UPD This is …

updating query-builder yii2
How can I select specific Columns with createQueryBuilder in Doctrine ORM?

I'm using Doctrine createQueryBuilder() to construct queries in Symfony2. But, I don't want to take all columns in this entity. …

php symfony orm query-builder
Subquery in doctrine2 notIN Function

I'd like to select members who are not in specific service. I have 3 tables : membre service membre_service (relation between …

php doctrine-orm query-builder
Symfony2 Doctrine querybuilder where IN

I losted trilion hours google this but none of the solutions were good. I have this querybuilder: $qb2=$this->…

doctrine dql query-builder
Using JOIN in Symfony2/Doctrine SQL

I have a problem while trying to USE QueryBuilder OR DQL. I have the following relation: User <-1:n-&…

php symfony doctrine dql query-builder
Laravel 5.1 Create or Update on Duplicate

In Laravel 5.1, for MySQL insert, I want to see if the record already exists and update on duplicate or create …

laravel laravel-5 eloquent query-builder
DB->count() returning different value from count(DB->get())

I have the simplest of queries that I'm trying to run DB::table('user_visits')->groupBy('user_id')…

laravel laravel-4 query-builder
yii2 ActiveQuery 'OR LIKE' filter

i have a task - add to search model searching by full name. Full name is first name + last name. …

yii2 query-builder