Yii2 : Quoting table and column names

To avoid column quoting when creating a query string , use [[columnName]] for columns and {{table_name}} for tables for example $result = \Yii::$app->db ->createCommand("SELECT COUNT([[id]]) FROM {{tbl_user_accounts}}") ->queryScalar();