Put `SELECT TOP 1000` or `SELECT statement` in new query window

First - Postico seems like I could love it. I'm hopeful. But my all time biggest time saving function is missing.

I just bought Postico today and immediately right clicked on a few tables in my database looking for the famous "SELECT TOP 1000" or "Put SELECT In New query window..." or something like that. No love.

The number one thing I need a sql client for is to write custom sql statements quickly. I usually do that by automatically producing the queries to select the fields from different tables that I'll be joining. If I have to type all those fields by hand, it would take forever. And SELECT * is not an option for production code that I'll be handing off to clients. I need explicit code that defines the queries I'll be running field by field. Unless I'm missing it, it looks like I'll have to type those out manually in Postico unless I use some clunky workarounds like altering ddl scripts or selecting from the information_schema.columns.

I'd love to see a right-click option or something like that to put a SELECT field1, field2, field3, etc. FROM table statement into a blank query window. That would be awesome.

Start at the table right-click/context-menu entry point and trace how a new query window is opened. Implement the requested explicit SELECT field1, field2, field3 FROM table action, then verify that it produces a usable query for the selected table.