Regarding Canada case. Article 2.024 of Canadian Electrical Code states that electrical equipment shall be approved, but lets local jurisdiction make the determination of which approvals are good.
For Quebec code, the super-seeding Article 2.024 lists a number of acceptable certifications and also allows exclusions for electrical equipment of less than 100VA and less than 30VDC, with certain limits regarding lighting, heating and other types of applications.
For Ontario code, the super-seeding Article 2.024 lists a number of acceptable certifications and also allows exclusions for electrical equipments powered by (on the load side of) 100VA or less Class 2 power supply with a voltage below 42V, with again certain limits regarding lighting, heating and other types of applications.
Therefore, the Ontario code is more restrictive that Quebec's code in that matter. As a general rule, when faced with using some CE European or non-CSA certified instruments in a project, using a 100VA Class 2 24VDC Power Source is a good rule to stay within the bounds of the electrical code Country-wide in Canada.
Still, the manufacturer of the equipment has to ensure proper electrical design so as not cause fire or other hazards. In the end, the equipment manufacturer (or the distributor of the equipment, or ultimately the importer of the equipment) is liable for its proper and safe design.