# Simple Queries

In this section, we will look at several examples of simple queries to the `users` table in our ORM system.

1. **Selecting All Users**

```typescript
const selectAllUsers = await databaseManager.queryBuilder<Users[]>()
    .select()
    .from('users')
    .execute();

console.log('Select All Users Query: ', selectAllUsers);
```

**Explanation:** This query selects all records from the `users` table. The `select()` method retrieves all columns from the table, while `from('users')` specifies the table from which the data is being selected. The `execute()` method runs the query and returns all records from the table.

2. **Selecting Active Users**

```typescript
const selectActiveUsers = await databaseManager.queryBuilder<Users[]>()
    .select()
    .from('users')
    .where({ conditions: { is_active: { eq: 'true' } } })
    .execute();

console.log('Select Active Users Query: ', selectActiveUsers);
```

**Explanation:** This query selects all active records from the `users` table. The `where` condition is used to filter results, selecting only those users where the `is_active` column equals `true`. The `execute()` method runs the query and returns the records that match the condition.

**3. Selecting a User by** `user_id`

```typescript
const selectUserByUserId = await databaseManager.queryBuilder<Users[]>()
    .select()
    .from('users')
    .where({ conditions: { user_id: { lt: 6 } } })
    .execute();

console.log('Select User by UserId Query: ', selectUserByUserId);
```

**Explanation:** This query selects users whose `user_id` is less than 6. The `where` condition uses the `lt` (less than) operator to filter records. The `execute()` method runs the query and returns the user data that meets the condition.

These examples demonstrate how to use my ORM system to execute simple queries on the `users` table using the `execute()` method. Queries can be modified or extended depending on the data selection requirements.