Doeke Zanstra

That looks like a work of art 😉! I think this is an issues with _htmlpreview.github.io_: it's a client-side solution. It uses [document.open/write/close](https://github.com/htmlpreview/htmlpreview.github.com/blob/master/htmlpreview.js#L66) to render the document. The HTML-source of...

I've synced upstream (calculator.html was added), so this PR will merge again. Also, I've replaced the preview URL from `htmlpreview.github.io` to something configurable, which defaults to `https://zserge.com/awfice` (see `.ok` file...

Python uses types for the queries; most types I use are text, integer, date/time (though at the moment date/time are ISO date strings; I'm new to Python). You could just...

I didn't think of that. Sounds that would work great!

Another reason for this feature, which is also using the `:name` format, [PugSQL](https://pugsql.org) which is a library for Python making it easy to use plain SQL files with parameters.

I've got a small issue: right-click on a JSONB cell, and select `Copy Cell` clear the copy/paste buffer, but doesn't copy the actual JSONB.

@martinjankoehler This fixes the issue. Also: this is a very welcome addition to Postico. I've also peeked at the JSON viewer in the v2 build. That also looks promising! I'm...

About JSON-validation: it's ultimately something Postgres would do, like it would with date and number validation. In the v2 beta I see there is validation in place, before data is...

This probably should work like [psql's variables](https://www.postgresql.org/docs/11/app-psql.html#APP-PSQL-VARIABLES), so you could also use special variables like `DBNAME`. Basically the most imporant one, for queries like `GRANT CONNECT ON DATABASE :DBNAME TO...

The nice thing about **psql**'s variables is the [interpolation](https://www.postgresql.org/docs/9.2/app-psql.html#APP-PSQL-INTERPOLATION). One could write this: ``` SELECT :'custom_name' as "name", :"custom_column" as "value" FROM some_table"` ``` And _psql_ will insert the value...