v6 How can I bind .withSchema() to all queries?

[sb4nt]

I am using AdonisJs v6 and Lucid orm, and have this working controller code but the middleware does not work:

export default class SubmissionController {
  constructor() {
    this.getSchema = this.getSchema.bind(this)
  }

  getSchema(request: HttpContext['request']) {
    const companyId = request.header('company-id')
    return `company_${companyId}`
  }

  async index({ request, response }: HttpContext) {
    const schema = this.getSchema(request)
    const submissions = await Submission.query().withSchema(schema)
    return response.ok(submissions)
  }

  async store({ request, response }: HttpContext) {
    const { data } = request.only(['data'])
    const schema = this.getSchema(request)

    const submission = await db
      .insertQuery()
      .withSchema(schema)
      .table('submissions')
      .insert({ data })
      .returning('*')
    return response.created(submission)
  }
}

Here's the middleware, I attempted which does not work:

export default class SetSchemaMiddleware {
  async handle(ctx: HttpContext, next: NextFn) {
    const companyId = ctx.request.header('company-id')
    const schema = `company_${companyId}`
    if (schema) {
//the following does not work
    //  db.query().withSchema(schema)
     // db.insertQuery().withSchema(schema)
    }
    await next()
  }
}

As the title suggests, I want the controller clean from any additional schema related task using a middleware.
Is there a way, where I can bind or assign or something to db call/query with .withSchema() and not have to append that in controller?
I basically want to change

const submissions = await Submission.query().withSchema(schema)

into

const submissions = await Submission.query()

Any help would be welcome.