I used XQuery at an old job where we received XML payloads from a third-party service and would use it to massage payloads that were malformed or that our system had a bug when processing them so that we could store the XQuery transformation in the database for auditing and reproducibility. It was a pretty unenjoyable experience and I would've preferred to manually edit the payloads directly but that's legacy systems for you.

Hopefully someone else can chime in and sell it better than me. 8^)

make sense! I might have similar thing on a pending project.

I've had to explain to an Albertan friend that hydro meant power, they mostly use coal out there from what I understand.

Alberta doesn't use any coal actually.

They have only recently finished phasing out coal, such that it appears in last year's statistics. And it's still mostly natural gas, i.e. a fossil fuel.

https://www.aeso.ca/aeso/understanding-electricity-in-albert...

It's a shame more people aren't taught gouda pronounce it.

Canadian here, we use the US sizes and describe them in inches (or by name, so we say "letter" or "8.5 by 11"). Microsoft Office uses both inches and millimetres but I always thought they did that for outside of Canada too.