I ordered neem cake fertiliser online. Dissolved the pellets in water to water the plants with. A fortnight and a few watering cycles later, every single gnat was gone. No sticky yellow, no sand.

The fuckers have been driving me insane for months, I have won the battle and the war. Get stuffed, gnats!