{"repo":"henvic/pgq","free":true,"listed":false,"github":"https://github.com/henvic/pgq","clone":"git clone https://github.com/henvic/pgq.git","description":"pgq is a query builder for PostgreSQL written in Go.","language":"Go","stars":70,"topics":["go","golang","postgres","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"pgq pgq is a query builder for PostgreSQL written in Go. It is a fork of Squirrel more suitable for working with the PostgreSQL database when you are able to use the native PostgreSQL protocol directly, rather than the slower textual protocol used by database/sql. You can use it with the pgx driver. Usage example Something like this: Main benefits API is crafted with only PostgreSQL compatibility so it has a somewhat lean API. It uses ANY and ALL operators for slices by default, which means it supports slices out of the box and you get to reuse your prepared statements. It's throughly tested (including integration tests to check for invalid queries being generated). If you already use pgx with Squirrel and the native PostgreSQL protocol, switching is very straightforward with just a few breaking changes (example: Alias is a type rather than a function). Main drawback It's still a query builder. You can go a long way writing pure SQL queries. Consider doing so. FAQ Why forking a query builder then? Whatever it takes to make people ditch using an ORM, I guess. See also pgtools pgxtutorial","default_branch":null,"files":null,"tree":[],"storefront":"/r/henvic","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/henvic/pgq/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}