Search Results for "sql sorting queries"

Beam is a Haskell interface to relational databases. Beam uses the Haskell type system to verify that queries are type-safe before sending them to the database server. Queries are written in a straightforward, natural monadic syntax. Combinators are provided for all standard SQL92 features, and a significant subset of SQL99, SQL2003, and SQL2008 features. Beam is standards-compliant but not naive. We recognize that different database backends provide different guarantees, syntaxes, and...

MILK is a lightweight Java database framework. Its main target is to simplify database development providing an easy-to-use API to run SQL queries and a slim configurable ORM.

Now stored at https://github.com/gregorydgraham/DBvolution Available from Maven Central: nz.co.gregs.dbvolution Makes relational data easy and fast to use with semantic annotations and encapsulated datatypes. Simple declaration of a DB table: @DBTableName("mytable") public class MyTable extends DBRow { @DBColumn("numeric_code") @DBForeignKey(Code.class) private DBNumber numericCode = new DBNumber(); @DBColumn("uid_mytable") @DBPrimaryKey @DBAutoIncrement private...

MockSqlBuilder uses mock objects and method interception to build SQL queries in an OOP fashion. Instead of strings (like HQL or plain text), MockSqlBuilder uses the data object's and their methods to record and construct a query.

Criteria2JPQL API is an adaptation of the powerful Hibernate Criteria API to standard JPA API enabling the compatibility with any orm tool. Against the native SQL queries created by Hibernate Criteria, Criteria2JPQL outputs standard JPQL queries.