Have you tried await strapi.db.connection.raw( 'SQL goes here' )?
await strapi.db.connection.raw( 'SQL goes here' )