DB

You can access the MaplePHP built in MySQL library through the provider.

$this->db = $this->provider->DB();

Then access the DB library:

$select = $this->db::select("id,firstname,lastname", ["users", "aliasA"])->whereId(1)->where("status", 0, ">")->limit(1);
$obj = $select->get(); // Get one row result as object

Click here for full MySQL query guide