The union representing workers at Aston Martin has welcomed the pending sale of the famous sportscar maker to a consortium led by UK-based vehicle development and motorsport group Prodrive.