rawQuery exception shouldn't return SQL in production

[Drun555]

I'm really sorry if it's something obvious, but I couldn't find any solution to this. When I use rawQuery, it outputs full SQL query into 'message' in case of exception - which is, of course, far from expected in production.

What's my options here? Is there some way to output error itself only? My only idea right now is to detect crash in rawQuery in handler.ts/handle, and then cut error by myself - which not only sounds stupid, but also could be dangerous.

[Drun555]

I ended up with adding safeRawQuery method to Database. My steps:

1. Created helpers/extensions.ts and providers/app_provider.ts
2. Registered app_provider in adonisrc.ts:

providers: [
...
() => import('./app/providers/app_provider.js')
]

3. Added extensions.ts to app_provider:

export default class AppProvider {
    async boot() {
      await import('../helpers/extensions.js')
    }
}

4. In extensions.ts, I added new method safeRawQuery to Database, which masquerades message if we're in production:

import { Database } from '@adonisjs/lucid/database';
import { DatabaseClientOptions } from '@adonisjs/lucid/types/database';

declare module '@adonisjs/lucid/database' {
    interface Database {
        safeRawQuery(sql: string, bindings?: any, options?: DatabaseClientOptions): any
    }
}

Database.macro('safeRawQuery', async function (this: Database, sql: string, bindings?: any, options?: DatabaseClientOptions) { 
    try {
        return await this.rawQuery(...[sql, bindings, options])
    } catch (e) {
        if (process.env.NODE_ENV === "production")
            e.message = "SQL Exception"

        throw e;
    }
})

At least, it works for me. I would prefer if I could somehow just trim SQL query from the answer, but it's beyond my scope right now. Hope it'll help someone in the future.