Craft 3: Get Data from a custom Table via createCommand()

Question

In Craft 2 you could creat a query with:

craft()->db->createCommand()->select() .... etc.

But in Craft 3 there is no select() Method in Craft::$app->db->createCommand().

Am I overlooking something?

Answer 1

You can use either an activeRecord for it

$customer = Customer::find() 
    ->where(['id' => 123]) 
    ->one();

Or a query

$rows = (new \craft\db\Query()) 
    ->select(['id', 'email']) 
    ->from('user') 
    ->where(['last_name' => 'Smith']) 
    ->limit(10)
     ->all();