I have a query like this (native sql)
SELECT
DISTINCT(P.product_variant_code) AS product_variant_code,
P.product_name AS product_name,
P.variant_name AS variant_name,
P.is_host_to_host AS is_host_to_host,
P.has_child AS has_child,
P.variant_options AS variant_options,