[willcipriano]

I like Datagrip for writing SQL for this purpose.

[lovingCranberry]

I've used to write my queries in pgAdmin or VSCode.

I downloaded DataGrip after reading your comment, and damn, the autocomplete is just so good. It even shows me the arguments of Postgresql extensions like TimescaleDB.

This almost reads like an ad, but I just wanted to thank you for changing my life :P