Query Builder

Introduction

Lunox's Query Builder is essentially inherited from Knex's Query Builder. Lunox wraps the Knex query builder into the DB facade, allowing it to be used anywhere in your application.

Running the Query Builder

To start using the query builder, the DB facade provides the table method. This method returns the Knex Query Builder, so you can simply use DB.table('table_name') to access all the features of the Knex Query Builder.

import { DB } from "@lunoxjs/eloquent";

await DB.table("users")
  .join("contacts", "users.id", "=", "contacts.user_id")
  .select("users.id", "contacts.phone");

info

Please refer to the Knex's Query Builder documentation for a complete list of query builder methods and features.