1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
//! <div align="center">
//!
//! <img alt="SeaORM" src="https://www.sea-ql.org/blog/img/SeaORM 2.0 Banner.png"/>
//!
//! <h1></h1>
//! <h3>SeaORM is a powerful ORM for building web services in Rust</h3>
//!
//! [](https://crates.io/crates/sea-orm)
//! [](https://github.com/SeaQL/sea-orm/actions/workflows/rust.yml)
//! [](https://github.com/SeaQL/sea-orm/stargazers/)
//! <br>Support us with a β !
//!
//! </div>
//!
//! # π SeaORM
//!
//! [δΈζζζ‘£](https://github.com/SeaQL/sea-orm/blob/master/README-zh.md)
//!
//! ### Advanced Relations
//!
//! Model complex relationships 1-1, 1-N, M-N, and even self-referential in a high-level, conceptual way.
//!
//! ### Familiar Concepts
//!
//! Inspired by popular ORMs in the Ruby, Python, and Node.js ecosystem, SeaORM offers a developer experience that feels instantly recognizable.
//!
//! ### Feature Rich
//!
//! SeaORM is a batteries-included ORM with filters, pagination, and nested queries to accelerate building REST, GraphQL, and gRPC APIs.
//!
//! ### Production Ready
//!
//! With 250k+ weekly downloads, SeaORM is production-ready, trusted by startups and enterprises worldwide.
//!
//! ## Getting Started
//!
//! [](https://discord.com/invite/uCPdDXzbdv)
//! Join our Discord server to chat with others!
//!
//! + [Documentation](https://www.sea-ql.org/SeaORM)
//!
//! Integration examples:
//!
//! + [Actix Example](https://github.com/SeaQL/sea-orm/tree/master/examples/actix_example)
//! + [Axum Example](https://github.com/SeaQL/sea-orm/tree/master/examples/axum_example)
//! + [GraphQL Example](https://github.com/SeaQL/sea-orm/tree/master/examples/graphql_example)
//! + [jsonrpsee Example](https://github.com/SeaQL/sea-orm/tree/master/examples/jsonrpsee_example)
//! + [Loco Example](https://github.com/SeaQL/sea-orm/tree/master/examples/loco_example) / [Loco REST Starter](https://github.com/SeaQL/sea-orm/tree/master/examples/loco_starter)
//! + [Poem Example](https://github.com/SeaQL/sea-orm/tree/master/examples/poem_example)
//! + [Rocket Example](https://github.com/SeaQL/sea-orm/tree/master/examples/rocket_example) / [Rocket OpenAPI Example](https://github.com/SeaQL/sea-orm/tree/master/examples/rocket_okapi_example)
//! + [Salvo Example](https://github.com/SeaQL/sea-orm/tree/master/examples/salvo_example)
//! + [Tonic Example](https://github.com/SeaQL/sea-orm/tree/master/examples/tonic_example)
//! + [Seaography Example (Bakery)](https://github.com/SeaQL/sea-orm/tree/master/examples/seaography_example) / [Seaography Example (Sakila)](https://github.com/SeaQL/seaography/tree/main/examples/sqlite)
//!
//! If you want a simple, clean example that fits in a single file that demonstrates the best of SeaORM, you can try:
//! + [Quickstart](https://github.com/SeaQL/sea-orm/blob/master/examples/quickstart/src/main.rs)
//!
//! Let's have a quick walk through of the unique features of SeaORM.
//!
//! ## Expressive Entity format
//! You don't have to write this by hand! Entity files can be generated from an existing database using `sea-orm-cli`,
//! following is generated with `--entity-format dense` *(new in 2.0)*.
//! ```
//! # #[cfg(feature = "macros")]
//! # mod entities {
//! # mod profile {
//! # use sea_orm::entity::prelude::*;
//! # #[sea_orm::model]
//! # #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
//! # #[sea_orm(table_name = "profile")]
//! # pub struct Model {
//! # #[sea_orm(primary_key)]
//! # pub id: i32,
//! # pub picture: String,
//! # #[sea_orm(unique)]
//! # pub user_id: i32,
//! # #[sea_orm(belongs_to, from = "user_id", to = "id")]
//! # pub user: HasOne<super::user::Entity>,
//! # }
//! # impl ActiveModelBehavior for ActiveModel {}
//! # }
//! # mod tag {
//! # use sea_orm::entity::prelude::*;
//! # #[sea_orm::model]
//! # #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
//! # #[sea_orm(table_name = "post")]
//! # pub struct Model {
//! # #[sea_orm(primary_key)]
//! # pub id: i32,
//! # #[sea_orm(has_many, via = "post_tag")]
//! # pub tags: HasMany<super::tag::Entity>,
//! # }
//! # impl ActiveModelBehavior for ActiveModel {}
//! # }
//! # mod post_tag {
//! # use sea_orm::entity::prelude::*;
//! # #[sea_orm::model]
//! # #[derive(Clone, Debug, PartialEq, DeriveEntityModel, Eq)]
//! # #[sea_orm(table_name = "post_tag")]
//! # pub struct Model {
//! # #[sea_orm(primary_key, auto_increment = false)]
//! # pub post_id: i32,
//! # #[sea_orm(primary_key, auto_increment = false)]
//! # pub tag_id: i32,
//! # #[sea_orm(belongs_to, from = "post_id", to = "id")]
//! # pub post: Option<super::post::Entity>,
//! # #[sea_orm(belongs_to, from = "tag_id", to = "id")]
//! # pub tag: Option<super::tag::Entity>,
//! # }
//! # impl ActiveModelBehavior for ActiveModel {}
//! # }
//! mod user {
//! use sea_orm::entity::prelude::*;
//!
//! #[sea_orm::model]
//! #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
//! #[sea_orm(table_name = "user")]
//! pub struct Model {
//! #[sea_orm(primary_key)]
//! pub id: i32,
//! pub name: String,
//! #[sea_orm(unique)]
//! pub email: String,
//! #[sea_orm(has_one)]
//! pub profile: HasOne<super::profile::Entity>,
//! #[sea_orm(has_many)]
//! pub posts: HasMany<super::post::Entity>,
//! }
//! # impl ActiveModelBehavior for ActiveModel {}
//! }
//! mod post {
//! use sea_orm::entity::prelude::*;
//!
//! #[sea_orm::model]
//! #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
//! #[sea_orm(table_name = "post")]
//! pub struct Model {
//! #[sea_orm(primary_key)]
//! pub id: i32,
//! pub user_id: i32,
//! pub title: String,
//! #[sea_orm(belongs_to, from = "user_id", to = "id")]
//! pub author: HasOne<super::user::Entity>,
//! #[sea_orm(has_many, via = "post_tag")] // M-N relation with junction
//! pub tags: HasMany<super::tag::Entity>,
//! }
//! # impl ActiveModelBehavior for ActiveModel {}
//! }
//! # }
//! ```
//!
//! ## Smart Entity Loader
//! The Entity Loader intelligently uses join for 1-1 and data loader for 1-N relations,
//! eliminating the N+1 problem even when performing nested queries.
//! ```
//! # use sea_orm::{DbConn, DbErr, prelude::*, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! // join paths:
//! // user -> profile
//! // user -> post
//! // post -> post_tag -> tag
//! let smart_user = user::Entity::load()
//! .filter_by_id(42) // shorthand for .filter(user::COLUMN.id.eq(42))
//! .with(profile::Entity) // 1-1 uses join
//! .with((post::Entity, tag::Entity)) // 1-N uses data loader
//! .one(db)?
//! .unwrap();
//!
//! // 3 queries are executed under the hood:
//! // 1. SELECT FROM user JOIN profile WHERE id = $
//! // 2. SELECT FROM post WHERE user_id IN (..)
//! // 3. SELECT FROM tag JOIN post_tag WHERE post_id IN (..)
//!
//! smart_user
//! == user::ModelEx {
//! id: 42,
//! name: "Bob".into(),
//! email: "bob@sea-ql.org".into(),
//! profile: HasOne::Loaded(
//! profile::ModelEx {
//! # id: 1,
//! picture: "image.jpg".into(),
//! # user_id: 1,
//! # user: HasOne::Unloaded,
//! }
//! .into(),
//! ),
//! posts: HasMany::Loaded(vec![post::ModelEx {
//! # id: 2,
//! # user_id: 1,
//! title: "Nice weather".into(),
//! # author: HasOne::Unloaded,
//! # comments: HasMany::Unloaded,
//! tags: HasMany::Loaded(vec![tag::ModelEx {
//! # id: 3,
//! tag: "sunny".into(),
//! # posts: HasMany::Unloaded,
//! }]),
//! }]),
//! };
//! # Ok(())
//! # }
//! ```
//!
//! ## ActiveModel: nested persistence made simple
//! Persist an entire object graph: user, profile (1-1), posts (1-N), and tags (M-N)
//! in a single operation using a fluent builder API. SeaORM automatically determines
//! the dependencies and inserts or deletes objects in the correct order.
//!
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! // this creates the nested object as shown above:
//! let user = user::ActiveModel::builder()
//! .set_name("Bob")
//! .set_email("bob@sea-ql.org")
//! .set_profile(profile::ActiveModel::builder().set_picture("image.jpg"))
//! .add_post(
//! post::ActiveModel::builder()
//! .set_title("Nice weather")
//! .add_tag(tag::ActiveModel::builder().set_tag("sunny")),
//! )
//! .save(db)?;
//! # Ok(())
//! # }
//! ```
//!
//! ## Schema first or Entity first? Your choice
//!
//! SeaORM provides a powerful migration system that lets you create tables, modify schemas, and seed data with ease.
//!
//! With SeaORM 2.0, you also get a first-class [Entity First Workflow](https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/):
//! simply define new entities or add columns to existing ones,
//! and SeaORM will automatically detect the changes and create the new tables, columns, unique keys, and foreign keys.
//!
//! ```ignore
//! // SeaORM resolves foreign key dependencies and creates the tables in topological order.
//! // Requires the `entity-registry` and `schema-sync` feature flags.
//! db.get_schema_registry("my_crate::entity::*").sync(db);
//! ```
//!
//! ## Ergonomic Raw SQL
//!
//! Let SeaORM handle 95% of your transactional queries.
//! For the remaining cases that are too complex to express,
//! SeaORM still offers convenient support for writing raw SQL.
//! ```
//! # use sea_orm::{DbErr, DbConn};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! # use sea_orm::{entity::*, query::*, tests_cfg::*, raw_sql};
//! # struct Item<'a> { name: &'a str }
//! let user = Item { name: "Bob" }; // nested parameter access
//! let ids = [2, 3, 4]; // expanded by the `..` operator
//!
//! let user: Option<user::Model> = user::Entity::find()
//! .from_raw_sql(raw_sql!(
//! Sqlite,
//! r#"SELECT "id", "name" FROM "user"
//! WHERE "name" LIKE {user.name}
//! AND "id" in ({..ids})
//! "#
//! ))
//! .one(db)?;
//! # Ok(())
//! # }
//! ```
//!
//! ## Synchronous Support
//!
//! [`sea-orm-sync`](https://crates.io/crates/sea-orm-sync) provides the full SeaORM API without requiring an runtime, making it ideal for lightweight CLI programs with SQLite.
//!
//! See the [quickstart example](https://github.com/SeaQL/sea-orm/blob/master/sea-orm-sync/examples/quickstart/src/main.rs) for usage.
//!
//! ## Basics
//!
//! ### Select
//! SeaORM models 1-N and M-N relationships at the Entity level,
//! letting you traverse many-to-many links through a junction table in a single call.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! // find all models
//! let cakes: Vec<cake::Model> = Cake::find().all(db)?;
//!
//! // find and filter
//! let chocolate: Vec<cake::Model> = Cake::find()
//! .filter(Cake::COLUMN.name.contains("chocolate"))
//! .all(db)?;
//!
//! // find one model
//! let cheese: Option<cake::Model> = Cake::find_by_id(1).one(db)?;
//! let cheese: cake::Model = cheese.unwrap();
//!
//! // find related models (lazy)
//! let fruit: Option<fruit::Model> = cheese.find_related(Fruit).one(db)?;
//!
//! // find related models (eager): for 1-1 relations
//! let cake_with_fruit: Vec<(cake::Model, Option<fruit::Model>)> =
//! Cake::find().find_also_related(Fruit).all(db)?;
//!
//! // find related models (eager): works for both 1-N and M-N relations
//! let cake_with_fillings: Vec<(cake::Model, Vec<filling::Model>)> = Cake::find()
//! .find_with_related(Filling) // for M-N relations, two joins are performed
//! .all(db) // rows are automatically consolidated by left entity
//! ?;
//! # Ok(())
//! # }
//! ```
//! ### Nested Select
//!
//! Partial models prevent overfetching by letting you querying only the fields
//! you need; it also makes writing deeply nested relational queries simple.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! use sea_orm::DerivePartialModel;
//!
//! #[derive(DerivePartialModel)]
//! #[sea_orm(entity = "cake::Entity")]
//! struct CakeWithFruit {
//! id: i32,
//! name: String,
//! #[sea_orm(nested)]
//! fruit: Option<fruit::Model>, // this can be a regular or another partial model
//! }
//!
//! let cakes: Vec<CakeWithFruit> = Cake::find()
//! .left_join(fruit::Entity) // no need to specify join condition
//! .into_partial_model() // only the columns in the partial model will be selected
//! .all(db)?;
//! # Ok(())
//! # }
//! ```
//!
//! ### Insert
//! SeaORM's ActiveModel lets you work directly with Rust data structures and
//! persist them through a simple API.
//! It's easy to insert large batches of rows from different data sources.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! let apple = fruit::ActiveModel {
//! name: Set("Apple".to_owned()),
//! ..Default::default() // no need to set primary key
//! };
//!
//! let pear = fruit::ActiveModel {
//! name: Set("Pear".to_owned()),
//! ..Default::default()
//! };
//!
//! // insert one: Active Record style
//! let apple = apple.insert(db)?;
//! apple.id == 1;
//! # let apple = fruit::ActiveModel {
//! # name: Set("Apple".to_owned()),
//! # ..Default::default() // no need to set primary key
//! # };
//!
//! // insert one: repository style
//! let result = Fruit::insert(apple).exec(db)?;
//! result.last_insert_id == 1;
//! # let apple = fruit::ActiveModel {
//! # name: Set("Apple".to_owned()),
//! # ..Default::default() // no need to set primary key
//! # };
//!
//! // insert many returning last insert id
//! let result = Fruit::insert_many([apple, pear]).exec(db)?;
//! result.last_insert_id == Some(2);
//! # Ok(())
//! # }
//! ```
//!
//! ### Insert (advanced)
//! You can take advantage of database specific features to perform upsert and idempotent insert.
//! ```
//! # use sea_orm::{DbConn, TryInsertResult, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function_1(db: &DbConn) -> Result<(), DbErr> {
//! # let apple = fruit::ActiveModel {
//! # name: Set("Apple".to_owned()),
//! # ..Default::default() // no need to set primary key
//! # };
//! # let pear = fruit::ActiveModel {
//! # name: Set("Pear".to_owned()),
//! # ..Default::default()
//! # };
//! // insert many with returning (if supported by database)
//! let models: Vec<fruit::Model> = Fruit::insert_many([apple, pear]).exec_with_returning(db)?;
//! models[0]
//! == fruit::Model {
//! id: 1, // database assigned value
//! name: "Apple".to_owned(),
//! cake_id: None,
//! };
//! # Ok(())
//! # }
//!
//! # fn function_2(db: &DbConn) -> Result<(), DbErr> {
//! # let apple = fruit::ActiveModel {
//! # name: Set("Apple".to_owned()),
//! # ..Default::default() // no need to set primary key
//! # };
//! # let pear = fruit::ActiveModel {
//! # name: Set("Pear".to_owned()),
//! # ..Default::default()
//! # };
//! // insert with ON CONFLICT on primary key do nothing, with MySQL specific polyfill
//! let result = Fruit::insert_many([apple, pear])
//! .on_conflict_do_nothing()
//! .exec(db)?;
//!
//! matches!(result, TryInsertResult::Conflicted);
//! # Ok(())
//! # }
//! ```
//!
//! ### Update
//! ActiveModel avoids race conditions by updating only the fields you've changed,
//! never overwriting untouched columns.
//! You can also craft complex bulk update queries with a fluent query building API.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! use sea_orm::sea_query::{Expr, Value};
//!
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! let pear: Option<fruit::Model> = Fruit::find_by_id(1).one(db)?;
//! let mut pear: fruit::ActiveModel = pear.unwrap().into();
//!
//! pear.name = Set("Sweet pear".to_owned()); // update value of a single field
//!
//! // update one: only changed columns will be updated
//! let pear: fruit::Model = pear.update(db)?;
//!
//! // update many: UPDATE "fruit" SET "cake_id" = "cake_id" + 2
//! // WHERE "fruit"."name" LIKE '%Apple%'
//! Fruit::update_many()
//! .col_expr(fruit::COLUMN.cake_id, fruit::COLUMN.cake_id.add(2))
//! .filter(fruit::COLUMN.name.contains("Apple"))
//! .exec(db)?;
//! # Ok(())
//! # }
//! ```
//! ### Save
//! You can perform "insert or update" operation with ActiveModel, making it easy to compose transactional operations.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! let banana = fruit::ActiveModel {
//! id: NotSet,
//! name: Set("Banana".to_owned()),
//! ..Default::default()
//! };
//!
//! // create, because primary key `id` is `NotSet`
//! let mut banana = banana.save(db)?;
//!
//! banana.id == Unchanged(2);
//! banana.name = Set("Banana Mongo".to_owned());
//!
//! // update, because primary key `id` is present
//! let banana = banana.save(db)?;
//! # Ok(())
//! # }
//! ```
//! ### Delete
//! The same ActiveModel API consistent with insert and update.
//! ```
//! # use sea_orm::{DbConn, DbErr, entity::*, query::*, tests_cfg::*};
//! # fn function(db: &DbConn) -> Result<(), DbErr> {
//! // delete one: Active Record style
//! let orange: Option<fruit::Model> = Fruit::find_by_id(1).one(db)?;
//! let orange: fruit::Model = orange.unwrap();
//! orange.delete(db)?;
//!
//! // delete one: repository style
//! let orange = fruit::ActiveModel {
//! id: Set(2),
//! ..Default::default()
//! };
//! fruit::Entity::delete(orange).exec(db)?;
//!
//! // delete many: DELETE FROM "fruit" WHERE "fruit"."name" LIKE '%Orange%'
//! fruit::Entity::delete_many()
//! .filter(fruit::COLUMN.name.contains("Orange"))
//! .exec(db)?;
//!
//! # Ok(())
//! # }
//! ```
//! ### Raw SQL Query
//! The `raw_sql!` macro is like the `format!` macro but without the risk of SQL injection.
//! It supports nested parameter interpolation, array and tuple expansion, and even repeating group,
//! offering great flexibility in crafting complex queries.
//!
//! ```
//! # use sea_orm::{DbErr, DbConn};
//! # fn functio(db: &DbConn) -> Result<(), DbErr> {
//! # use sea_orm::{query::*, FromQueryResult, raw_sql};
//! #[derive(FromQueryResult)]
//! struct CakeWithBakery {
//! name: String,
//! #[sea_orm(nested)]
//! bakery: Option<Bakery>,
//! }
//!
//! #[derive(FromQueryResult)]
//! struct Bakery {
//! #[sea_orm(alias = "bakery_name")]
//! name: String,
//! }
//!
//! let cake_ids = [2, 3, 4]; // expanded by the `..` operator
//!
//! // can use many APIs with raw SQL, including nested select
//! let cake: Option<CakeWithBakery> = CakeWithBakery::find_by_statement(raw_sql!(
//! Sqlite,
//! r#"SELECT "cake"."name", "bakery"."name" AS "bakery_name"
//! FROM "cake"
//! LEFT JOIN "bakery" ON "cake"."bakery_id" = "bakery"."id"
//! WHERE "cake"."id" IN ({..cake_ids})"#
//! ))
//! .one(db)?;
//! # Ok(())
//! # }
//! ```
//!
//! ## π§ Seaography: instant GraphQL API
//!
//! [Seaography](https://github.com/SeaQL/seaography) is a GraphQL framework built for SeaORM.
//! Seaography allows you to build GraphQL resolvers quickly.
//! With just a few commands, you can launch a fullly-featured GraphQL server from SeaORM entities,
//! complete with filter, pagination, relational queries and mutations!
//!
//! Look at the [Seaography Example](https://github.com/SeaQL/sea-orm/tree/master/examples/seaography_example) to learn more.
//!
//! <img src="https://raw.githubusercontent.com/SeaQL/sea-orm/master/examples/seaography_example/Seaography%20example.png"/>
//!
//! ## π₯οΈ SeaORM Pro: Professional Admin Panel
//!
//! [SeaORM Pro](https://github.com/SeaQL/sea-orm-pro/) is an admin panel solution allowing you to quickly and easily launch an admin panel for your application - frontend development skills not required, but certainly nice to have!
//!
//! SeaORM Pro has been updated to support the latest features in SeaORM 2.0.
//!
//! Features:
//!
//! + Full CRUD
//! + Built on React + GraphQL
//! + Built-in GraphQL resolver
//! + Customize the UI with TOML config
//! + Role Based Access Control *(new in 2.0)*
//!
//! Read the [Getting Started](https://www.sea-ql.org/sea-orm-pro/docs/install-and-config/getting-started/) guide to learn more.
//!
//! 
//! 
//!
//! ## SQL Server Support
//!
//! [SQL Server for SeaORM](https://www.sea-ql.org/SeaORM-X/) offers the same SeaORM API for MSSQL. We ported all test cases and examples, complemented by MSSQL specific documentation. If you are building enterprise software, you can [request commercial access](https://forms.office.com/r/1MuRPJmYBR). It is currently based on SeaORM 1.0, but we will offer free upgrade to existing users when SeaORM 2.0 is finalized.
//!
//! ## Releases
//!
//! SeaORM 2.0 has reached its release candidate phase. We'd love for you to try it out and help shape the final release by [sharing your feedback](https://github.com/SeaQL/sea-orm/discussions/).
//!
//! + [Change Log](https://github.com/SeaQL/sea-orm/tree/master/CHANGELOG.md)
//!
//! SeaORM 2.0 is shaping up to be our most significant release yet - with a few breaking changes, plenty of enhancements, and a clear focus on developer experience.
//!
//! + [A Sneak Peek at SeaORM 2.0](https://www.sea-ql.org/blog/2025-09-16-sea-orm-2.0/)
//! + [SeaORM 2.0: A closer look](https://www.sea-ql.org/blog/2025-09-24-sea-orm-2.0/)
//! + [Role Based Access Control in SeaORM 2.0](https://www.sea-ql.org/blog/2025-09-30-sea-orm-rbac/)
//! + [Seaography 2.0: A Powerful and Extensible GraphQL Framework](https://www.sea-ql.org/blog/2025-10-08-seaography/)
//! + [SeaORM 2.0: New Entity Format](https://www.sea-ql.org/blog/2025-10-20-sea-orm-2.0/)
//! + [SeaORM 2.0: Entity First Workflow](https://www.sea-ql.org/blog/2025-10-30-sea-orm-2.0/)
//! + [SeaORM 2.0: Strongly-Typed Column](https://www.sea-ql.org/blog/2025-11-11-sea-orm-2.0/)
//! + [What's new in SeaORM Pro 2.0](https://www.sea-ql.org/blog/2025-11-21-whats-new-in-seaormpro-2.0/)
//! + [SeaORM 2.0: Nested ActiveModel](https://www.sea-ql.org/blog/2025-11-25-sea-orm-2.0/)
//! + [A walk-through of SeaORM 2.0](https://www.sea-ql.org/blog/2025-12-05-sea-orm-2.0/)
//! + [How we made SeaORM synchronous](https://www.sea-ql.org/blog/2025-12-12-sea-orm-2.0/)
//! + [SeaORM 2.0 Migration Guide](https://www.sea-ql.org/blog/2026-01-12-sea-orm-2.0/)
//! + [SeaORM now supports Arrow & Parquet](https://www.sea-ql.org/blog/2026-02-22-sea-orm-arrow/)
//! + [SeaORM 2.0 with SQL Server Support](https://www.sea-ql.org/blog/2026-02-25-sea-orm-x/)
//!
//! If you make extensive use of SeaQuery, we recommend checking out our blog post on SeaQuery 1.0 release:
//!
//! + [The road to SeaQuery 1.0](https://www.sea-ql.org/blog/2025-08-30-sea-query-1.0/)
//!
//! ## License
//!
//! Licensed under either of
//!
//! - Apache License, Version 2.0
//! ([LICENSE-APACHE](LICENSE-APACHE) or <http://www.apache.org/licenses/LICENSE-2.0>)
//! - MIT license
//! ([LICENSE-MIT](LICENSE-MIT) or <http://opensource.org/licenses/MIT>)
//!
//! at your option.
//!
//! ## Contribution
//!
//! Unless you explicitly state otherwise, any contribution intentionally submitted
//! for inclusion in the work by you, as defined in the Apache-2.0 license, shall be
//! dual licensed as above, without any additional terms or conditions.
//!
//! We invite you to participate, contribute and together help build Rust's future.
//!
//! A big shout out to our contributors!
//!
//! [](https://github.com/SeaQL/sea-orm/graphs/contributors)
//!
//! ## Who's using SeaORM?
//!
//! Here is a short list of awesome open source software built with SeaORM. Feel free to [submit yours](https://github.com/SeaQL/sea-orm/blob/master/COMMUNITY.md#built-with-seaorm)!
//!
//! | Project | GitHub | Tagline |
//! |---------|--------|---------|
//! | [Zed](https://github.com/zed-industries/zed) |  | A high-performance, multiplayer code editor |
//! | [OpenObserve](https://github.com/openobserve/openobserve) |  | Open-source observability platform |
//! | [RisingWave](https://github.com/risingwavelabs/risingwave) |  | Stream processing and management platform |
//! | [LLDAP](https://github.com/nitnelave/lldap) |  | A light LDAP server for user management |
//! | [Warpgate](https://github.com/warp-tech/warpgate) |  | Smart SSH bastion that works with any SSH client |
//! | [Svix](https://github.com/svix/svix-webhooks) |  | The enterprise ready webhooks service |
//! | [Ryot](https://github.com/IgnisDa/ryot) |  | The only self hosted tracker you will ever need |
//! | [Lapdev](https://github.com/lapce/lapdev) |  | Self-hosted remote development enviroment |
//! | [System Initiative](https://github.com/systeminit/si) |  | DevOps Automation Platform |
//! | [OctoBase](https://github.com/toeverything/OctoBase) |  | A light-weight, scalable, offline collaborative data backend |
//!
//! ## Sponsorship
//!
//! [SeaQL.org](https://www.sea-ql.org/) is an independent open-source organization run by passionate developers.
//! If you feel generous, a small donation via [GitHub Sponsor](https://github.com/sponsors/SeaQL) will be greatly appreciated, and goes a long way towards sustaining the organization.
//!
//! ### Gold Sponsors
//!
//! <table><tr>
//! <td><a href="https://qdx.co/">
//! <img src="https://www.sea-ql.org/static/sponsors/QDX.svg" width="138"/>
//! </a></td>
//! </tr></table>
//!
//! [QDX](https://qdx.co/) pioneers quantum dynamics-powered drug discovery, leveraging AI and supercomputing to accelerate molecular modeling.
//! We're immensely grateful to QDX for sponsoring the development of SeaORM, the SQL toolkit that powers their data intensive applications.
//!
//! ### Silver Sponsors
//!
//! We're grateful to our silver sponsors: Digital Ocean, for sponsoring our servers. And JetBrains, for sponsoring our IDE.
//!
//! <table><tr>
//! <td><a href="https://www.digitalocean.com/">
//! <img src="https://www.sea-ql.org/static/sponsors/DigitalOcean.svg" width="125">
//! </a></td>
//!
//! <td><a href="https://www.jetbrains.com/">
//! <img src="https://www.sea-ql.org/static/sponsors/JetBrains.svg" width="125">
//! </a></td>
//! </tr></table>
//!
//! ## Mascot
//!
//! A friend of Ferris, Terres the hermit crab is the official mascot of SeaORM. His hobby is collecting shells.
//!
//! <img alt="Terres" src="https://www.sea-ql.org/SeaORM/img/Terres.png" width="400"/>
//!
//! ## π¦ Rustacean Sticker Pack
//! The Rustacean Sticker Pack is the perfect way to express your passion for Rust. Our stickers are made with a premium water-resistant vinyl with a unique matte finish.
//!
//! Sticker Pack Contents:
//!
//! + Logo of SeaQL projects: SeaQL, SeaORM, SeaQuery, Seaography
//! + Mascots: Ferris the Crab x 3, Terres the Hermit Crab
//! + The Rustacean wordmark
//!
//! [Support SeaQL and get a Sticker Pack!](https://www.sea-ql.org/sticker-pack/) All proceeds contributes directly to the ongoing development of SeaQL projects.
//!
//! <a href="https://www.sea-ql.org/sticker-pack/"><img alt="Rustacean Sticker Pack by SeaQL" src="https://www.sea-ql.org/static/sticker-pack-1s.jpg" width="600"/></a>
/// Module for the Entity type and operations
/// Error types for all database operations
/// This module performs execution of queries on a Model or ActiveModel
/// Types and methods to perform metric collection
/// Types and methods to perform queries
/// Types that defines the schemas of an Entity
/// Helpers for working with Value
pub use *;
pub use *;
pub use *;
pub use *;
pub use *;
pub use *;
pub use *;
pub use ;
pub use sea_query;
pub use Iden;
pub use EnumIter;
pub use strum;
pub use arrow;
pub use sqlx;