GitHub - maximebf/classql: A new kind of ORM for PHP 5.3

ClassQL is a new kind of ORM for PHP 5.3. Based on a custom syntax that wraps around SQL code, it allows to create "object oriented" SQL. No PHP is involved in your models: you define them in SQL!

User {
    
    // columns
    id int;
    email text;
    password text;
    firstName text;
    lastName text;
    
    // vars
    $fullName = firstName || ' ' || lastName;
    $SELECT = SELECT id, email, firstName, lastName, $fullName;
    
    // by default, methods returns a collection of their defining class
    // the keyword $this will be replaced by the table name
    static findAll() {
        $SELECT FROM $this
    }

    // this methods returns a single User object
    static findById($id) : self {
        $SELECT FROM $this WHERE id = $id
    }
    
    static count() : value {
        SELECT COUNT(*) FROM $this
    }
    
    // this method forwards the call to another one
    findMessages() -> Message::findAllByUserId($id)
}

Message {

    id int;
    user_id int references users(id);
    message text;

    static findAllByUserId($id) {
        SELECT * FROM $this WHERE user_id = $id
    }
}

$user = User::findById(1);
echo $user->email;
$messages = $user->findMessages();