Querydsl is a framework that enables the construction of statically typed SQL-like queries. Instead of writing queries as inline strings or externalizing them into XML files, they can be constructed via a fluentDSL/API like Querydsl. It supports JPA, JDO, Java Collections, SQL via JDBC, Lucene, and Hibernate Search.
Talend Open Studio for Data Quality helps you to profile your data. The ergonomic interface allows you to define metrics (indicators) and collect statistics on your data in a few clicks. It comes with a set of regular expressions that helps you to identify bad data. You can create your own regular expressions and use them in data profiling analyses. A lot of options exist for each indicator, which change the behavior of the indicator so that it gives you more pertinent information. Data quality options on indicators alert you when your data quality is not what you expected.
Cego implements a relational and transactional database system with support for the SQL query language. The current release contains the most common database features for basic table manipulation and data retrieval. Indexes, foreign keys, views, and stored procedures are also implemented. Future releases (2.0 and above) will support a multi-node database concept with log file shipping for an automatic database application failover.
MyJSQLView provides an easy-to-use Java based GUI frontend for viewing, adding, editing, or deleting data in the HSQL, MSAccess, MySQL, Oracle, PostgreSQL, and SQLite databases. A query tool allows the building of complex SQL statements. The application allows easy sorting, searching, and import/export of table data. A plug-in framework allows inclusion of tools to profile and plot data for analysis.