<?php

$query = new Books::find()->where('author=2');
//↓これ
echo $query->createCommand()->getRawSql();