# lambda-to-sql

**Repository Path**: VampireAchao/lambda-to-sql

## Basic Information

- **Project Name**: lambda-to-sql
- **Description**: lambda-to-sql
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2023-09-26
- **Last Updated**: 2023-12-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# lambda-to-sql

- 将lambda解析为sql

```js

DB.From(User.class).select(

    t -> t.columns(t.getId(), t.getName())

).leftJoin(

    t -> t.table(Role.class, (t, r)-> t.getRoleId()==r.getId())
        .columns(r.getId().as("roleId"), r.getRoleName())

).where(

    q -> q.and(p -> p.getStatus() != 0).and(p -> p.getName().contains("daily"))

).orderBy(t -> t.getAge())


SELECT t.id,t.name,r.id AS roleId,r.role_name

FROM user t LEFT JOIN role r ON t.role_id=r.id

WHERE t.status <> 0 AND t.name LIKE '%daily%' ORDER BY t.age

```

[来自项目](https://github.com/d4ilys/lambda-to-sql) 以上语法待实现