Re: Visual query builder for PosgreSQL?

Satoshi Nagayasu <snaga(at)uptime(dot)jp> wrote:

> Of course, I can write ad-hoc queries by myself. However, I'd
> like to allow non-tech people to issue ad-hoc queries with using
> some visual query builder.

You should probably take a look at http://htsql.org/

It is free open source software intended for "accidental
programmers" -- people who want to pull summarized data from a
database without learning SQL or needing rigorous training.  Its
development was partially funded by grants from foundations,
including the National Science Foundation.  It does support
PostgreSQL and most definitely support counts, sums, etc.  In fact,
it can automagically give you pretty summary graphs with the
ability to drill down to supporting detail.

-Kevin