UserTb::find().lock_shared().build(DatabaseBackend::MySql).to_string()) generates the wrong SQL statement for the old version of MySQL: SELECT `user_tb`.`id`, `user_tb`.`created_time`, ...
When using aliases in DELETE queries with JOINs in MySQL, Knex generates incorrect SQL syntax. The generated query includes the full table declaration with alias in the DELETE clause, but MySQL ...