ORM哪家强？java，c#，php，python，go 逐一对比， 网友直呼：全面客观

    select * from user
    
    insert user (name,mobile) values ('tang','18600000000')

    SELECT 
        article.*,
        person.name as person_name 
    FROM article 
    LEFT JOIN person ON person.id=article.person_id 
    WHERE article.type = 0 
    AND article.age IN (18,20)

    SELECT 
        o.*,
        d.department_name,
        (SELECT Sum(so.goods_fee) AS task_detail_target_completed_tem 
         FROM sale_order so 
         WHERE so.merchant_id = '356469725829664768' 
         AND so.create_date BETWEEN (20230127) AND (20230212) 
         AND so.delete_state = 2 
         AND so.department_id = o.department_id
        ) AS task_detail_target_completed 
    FROM task_detail o 
    LEFT JOIN department d ON d.department_id=o.department_id 
    WHERE o.merchant_id = '356469725829664768' 
    AND o.task_id = '356469725972271104768'

public class OrderModel {
    //订单编号
    Integer orderId;
    //用户编号
    Integer userId;
    //订单时间
    Integer createTime;
    //订单详情(包含商品编号，商品数量)
    String  orderDetail;
}

public class OrderEntity {
    Integer orderId;
    Integer userId;
    Integer createTime;
}

public class OrderDetailEntity {
    Integer orderDetailId;
    Integer orderId;
    Integer goodsId;
    Integer goodsCount;
}

<mapper namespace="xxx.mapper.UserMapper">
    <insert id="insertUser" parameterType="UserEntity">
        insert into user (id,name,mobile)
        values (#{id},#{name},#{mobile})
    </insert>

    <update id="updateUser" parameterType="UserEntity">
        update user set
        name = #{name},
        mobile = #{mobile}
        where id = #{id}
    </update>

    <delete id="deleteUser">
        delete from user where id = #{id}
    </delete>

    <select id="selectUsers" resultType="UserVO">
        select u.*, (select count(*) from article a where a.uid=u.id) as article_count
        from user u
        where u.id = #{id}
    </select>
</mapper>

    userService.insert(user);

    userService.update(user);

    userService.deleteById(user);

    List<UserEntity> userList = userService.selectList(queryWrapper);

public final class PersonDynamicSqlSupport {
    public static final Person person = new Person();
    public static final SqlColumn<Integer> id = person.id;
    public static final SqlColumn<String> firstName = person.firstName;
    public static final SqlColumn<LastName> lastName = person.lastName;
    public static final SqlColumn<Date> birthDate = person.birthDate;
    public static final SqlColumn<Boolean> employed = person.employed;
    public static final SqlColumn<String> occupation = person.occupation;
    public static final SqlColumn<Integer> addressId = person.addressId;

    public static final class Person extends SqlTable {
        public final SqlColumn<Integer> id = column("id", JDBCType.INTEGER);
        public final SqlColumn<String> firstName = column("first_name", JDBCType.VARCHAR);
        public final SqlColumn<LastName> lastName = column("last_name", JDBCType.VARCHAR, "examples.simple.LastNameTypeHandler");
        public final SqlColumn<Date> birthDate = column("birth_date", JDBCType.DATE);
        public final SqlColumn<Boolean> employed = column("employed", JDBCType.VARCHAR, "examples.simple.YesNoTypeHandler");
        public final SqlColumn<String> occupation = column("occupation", JDBCType.VARCHAR);
        public final SqlColumn<Integer> addressId = column("address_id", JDBCType.INTEGER);

        public Person() {
            super("Person");
        }
    }
}

        SelectStatementProvider selectStatement = select(id.as("A_ID"), firstName, lastName, birthDate, employed,occupation, addressId)
        .from(person)
        .where(id, isEqualTo(1))
        .or(occupation, isNull())
        .build()
        .render(RenderingStrategies.MYBATIS3);

        List<PersonRecord> rows = mapper.selectMany(selectStatement);

    var id = 1;
    var query = database.Posts
                .Join(database.Post_Metas,
                    post => post.ID,
                    meta => meta.Post_ID,
                    (post, meta) => new { Post = post, Meta = meta }
                )
                .Where(postAndMeta => postAndMeta.Post.ID == id);

$user = DB::table('users')->where('name', 'John')->first();

$repository = $this->getDoctrine()->getRepository('AppBundle:Product');
 
// query for a single product by its primary key (usually "id")
// 通过主键（通常是id）查询一件产品
$product = $repository->find($productId);
 
// dynamic method names to find a single product based on a column value
// 动态方法名称，基于字段的值来找到一件产品
$product = $repository->findOneById($productId);
$product = $repository->findOneByName('Keyboard');

// query for multiple products matching the given name, ordered by price
// 查询多件产品，要匹配给定的名称和价格
$products = $repository->findBy(
    array('name' => 'Keyboard'),
    array('price' => 'ASC')
);

    res=models.Author.objects.filter(name='jason').values('author_detail__phone','name')
    print(res)
    # 反向
    res = models.AuthorDetail.objects.filter(author__name='jason')  # 拿作者姓名是jason的作者详情
    res = models.AuthorDetail.objects.filter(author__name='jason').values('phone','author__name')
    print(res)


    # 2.查询书籍主键为1的出版社名称和书的名称
    res = models.Book.objects.filter(pk=1).values('title','publish__name')
    print(res)
    # 反向
    res = models.Publish.objects.filter(book__id=1).values('name','book__title')
    print(res)

result = session.               
query(User.username,func.count(Article.id)).
join(Article,User.id==Article.uid).
group_by(User.id).
order_by(func.count(Article.id).desc()).
all()

type User struct {
  Id  int
  Age int
}

type Order struct {
  UserId     int
  FinishedAt *time.Time
}

query := db.Table("order").
Select("MAX(order.finished_at) as latest").
Joins("left join user user on order.user_id = user.id").
Where("user.age > ?", 18).
Group("order.user_id")

db.Model(&Order{}).
Joins("join (?) q on order.finished_at = q.latest", query).
Scan(&results)

func newUser(db *gorm.DB) user {
	_user := user{}

	_user.userDo.UseDB(db)
	_user.userDo.UseModel(&model.User{})

	tableName := _user.userDo.TableName()
	_user.ALL = field.NewAsterisk(tableName)
	_user.ID = field.NewInt64(tableName, "id")
	_user.Name = field.NewString(tableName, "name")
	_user.Age = field.NewInt64(tableName, "age")
	_user.Balance = field.NewFloat64(tableName, "balance")
	_user.UpdatedAt = field.NewTime(tableName, "updated_at")
	_user.CreatedAt = field.NewTime(tableName, "created_at")
	_user.DeletedAt = field.NewField(tableName, "deleted_at")
	_user.Address = userHasManyAddress{
		db: db.Session(&gorm.Session{}),

		RelationField: field.NewRelation("Address", "model.Address"),
	}

	_user.fillFieldMap()

	return _user
}

u := query.User
err := u.WithContext(ctx).
    Select(u.Name, u.Age.Sum().As("total")).
    Group(u.Name).
    Having(u.Name.Eq("group")).
    Scan(&users)

// SELECT name, sum(age) as total FROM `users` GROUP BY `name` HAVING name = "group"

const (
	// Label holds the string label denoting the user type in the database.
	Label = "user"
	// FieldID holds the string denoting the id field in the database.
	FieldID = "id"
	// FieldName holds the string denoting the name field in the database.
	FieldName = "name"
	// FieldAge holds the string denoting the age field in the database.
	FieldAge = "age"
	// FieldAddress holds the string denoting the address field in the database.
	FieldAddress = "address"
	// Table holds the table name of the user in the database.
	Table = "users"
)

u, err := client.User.
        Query().
        Where(user.Name("realcp")).
        Only(ctx)

    type Person struct {
        Id         null.Int    `aorm:"primary;auto_increment" json:"id"`
        Name       null.String `aorm:"size:100;not null;comment:名字" json:"name"`
        Sex        null.Bool   `aorm:"index;comment:性别" json:"sex"`
        Age        null.Int    `aorm:"index;comment:年龄" json:"age"`
        Type       null.Int    `aorm:"index;comment:类型" json:"type"`
        CreateTime null.Time   `aorm:"comment:创建时间" json:"createTime"`
        Money      null.Float  `aorm:"comment:金额" json:"money"`
        Test       null.Float  `aorm:"type:double;comment:测试" json:"test"`
    }
	

    //Instantiation the struct
    var person = Person{}
	
    //Store the struct object
    aorm.Store(&person)

    var personItem Person
    err := aorm.Db(db).Table(&person).WhereEq(&person.Id, 1).OrderBy(&person.Id, builder.Desc).GetOne(&personItem)
    if err != nil {
        fmt.Println(err.Error())
    }