Thrilling Tilings at Tiring Timings

(Etienne here.) The date was 24 October 2021. It was late at night, and I was just about to tuck myself in. After all, the next day was the A-Level Physics practical! I needed to be well-rested (spoiler alert - I actually didn't). I was lying comfortably and about to bid a temporary farewell to the waking world, when suddenly, out of nowhere, I was attacked by a sudden thought: For what $r$ could I tile a square with rectangles whose sides had ratio $r$?