Flexible qery to list all promotions

SELECT * FROM {PromotionSourceRule AS PromotionSourceRule } ORDER BY {PromotionSourceRule:code} ASC