Query examples

User::columns(['id', 'email'])->getAll(['id' => [1,3]]);

User::columns(['id', 'email'])->where(['id' => [1,3]])->list();

SELECT id, email FROM users WHERE id IN (1,3);

{
    "id": "1",
    "email": "[e-mail]"
},
{
    "id": "3",
    "email": "[e-mail]"
}

User::columns(['id', 'CONCAT(firstName, " ", lastName)'])->listFlat();

{
    "1": "Hans Gruber",
    "2": "Lars Ulrich",
    "3": "Hans Nickerdorph",
    "4": "Henry Bakerstreet"
}