Idea for Query Builder

[mitchsatchwell]

To save on repetitive queries:

class getCustomerList extends SqlQuery {

	public function select () {
		return [
    			'id',
			'name'
			'status'
		];
	}

	public function from {
		return 'customer';
		// or another SqlQuery class:
		// return new getNestedQuery();
	}

	public function order {
		'created desc';
	}

}

class getCustomerListUnprocessed extends getCustomerList {

	public function where () {
		return array_merge(parent::where(), [
			'processed is null'
		]);
	}

}

[g105b]

This can be optionally used with no backwards incompatibilities: $db->fetch("customer.getAll") can look for the file query/customer/getAll.sql or query/customer/getAll.php.

[g105b]

The __toString function of the base class can build up the entire string in the correct order. The query output should be wrapped in brackets, along with the alias if it is passed into the constructor:

class MyQuery extends QueryBuilder {
	public function select() {
		return [
			"id",
			"some_alias.id as otherId",
		];
	}

	public function from() {
		return new SubQuery("some_alias");
	}
}

[g105b]

How would joins work? Are the order of joins important, and if not, when you need to override the query optimiser, how would you specify that in this style?

Idea:

public function join() {
	return [
		"inner join on customer.id = other.fk_customer",
		"straight_join using(id)",
	];
}