DISTINCT and Unique column with strapi

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