Stardust - A SQL-centric ORM framework Fork me on GitHub
	public void examples() {
	
		List<Customer> activeCustomersAndFeedback = daoManager
			.newQuery(Customer.class)
			.outerJoin(Feedback.class, "fb")
			.filterBy("active = ?", true)
			.filterBy("fb.deleted != ?", true)
			.orderBy("lastName")
			.list();
	
	}
	
	public void sqlDrivenQueryExamples() {
	
	/* Given a SQL (an actual SQL may be more complex):
		select customer_id, first_name, last_name, active,
		       fb.feeback_text fb_feedback_text, fb.deleted fb_deleted
		  from customer c
		           left outer join feedback fb
		               on (c.customer_id = fb.customer_id)
		 where c.active = :activeFlag
	*/
	
		List<Customer> activeCustomersAndFeedback = daoManager
			.newQuery(Customer.class)
			.outerJoin(Feedback.class, "fb")
			.backedBySql(simulatedComplexSQL)
			.filterBy("fb.deleted != ?", true)
			.assignParam("activeFlag", true)       // assign parameter defined in the SQL
			.orderBy("lastName")
			.list();

	}