DocsDatabaseQuery BuilderDatabaseQuery BuilderFluent SQL query builder with parameterized queries.1 min readDocumentationEdit this pageSELECT# typescriptconst users = await db .select('id', 'name', 'email') .from('users') .where('active', true) .orderBy('name', 'ASC') .limit(10) .all() INSERT# typescriptawait db.insert('users', { name: 'Tariq', email: 'tariq@axiljs.dev' }).execute() UPDATE# typescriptawait db.update('users').set({ name: 'Tariq Mehmood' }).where('id', 1).execute() DELETE# typescriptawait db.delete('users').where('id', 1).execute() WarningAll values are parameterized. Never concatenate user input into SQL.PreviousEntitiesNextRepositories
