Does anyone know of a tool like [PowerArchitect](http://www.sqlpower.ca/page/architect) or [SquirrelSQL](http://squirrel-sql.sourceforge.net/) or maybe eclipse plugin that lets you also generate jpa/sql queries?

Imagine you choosing your database, or your entity beans, and the modeling would reverse engineer your database/entity model, so that you could visually just choose the columns you wanted to select, and it would generate jpa or sql queries for you.

For instance choosing `A.b` and `X.y` would generate something like this:

```
select a.b, x.y from A a, X x join ......

```