The as_query method in the queryset.py file has been removed

[jsonvot]

Describe the bug
The as_query() method of the AwaitableQuery class was removed in version 0.24.0, and I haven't found any alternative method to replace it. This method was extremely useful for converting a queryset to a QueryBuilder. I'm wondering if this removal was an intentional/planned change, or an accidental one.

Here are two historical changes to this method:

[waketzheng]

Could you show code snippet of your use case?

[jsonvot]

For example, it is applied in some complex association query scenarios, but you do not want to use physical foreign keys.

from tortoise.models import Model

class User(Model):
	id
	name
	dept_id
	role_id

class Dept(Model):
	id
	name
	
class Role(Model):
	id
	name


tb_user = User._meta.basetable
tb_dept = Dept._meta.basetable
tb_role = Role._meta.basetable

query = (
	User.all().only('email', 'nickname', 'avatar').as_query().
	join(Dept.all().as_query()).on(tb_user.dept_id==tb_dept.id)
	join(Role.all().as_query()).on(tb_user.role_id==tb_role.id)
	select(
		tb_dept.name.as_('dept_name'),
		tb_role.name.as_('role_name')
	)
)
db = User._choose_db()
result = await  db.execute_query_dict(query.get_sql())

[waketzheng]

@henadzit Cloud you look at this