| SQL | Rust | |:----------------------|:--------------------------| |

SELECT * FROM Table

Table.all()

SELECT field1 FROM Table

Table.only(field1)

SELECT field1 FROM Table

Table.defer(pk) // Exclusion de champs.

SELECT * FROM Table WHERE field1 = "value1"

Table.filter(field1 == "value1")

SELECT * FROM Table WHERE primarykey = 42

Table.get(42)
// Raccourci pour :
Table.filter(primarykey == 42)[0..1];

SELECT * FROM Table WHERE field1 = 'value1'

Table.get(field1 == "value1")
// Raccourci pour :
Table.filter(field1 == "value1")[0..1];

SELECT * FROM Table WHERE field1 = "value1 AND field2 < 100

Table.filter(field1 == "value1" && field2 < 100)

SELECT * FROM Table WHERE field1 = "value1 OR field2 < 100

Table.filter(field1 == "value1" || field2 < 100)

SELECT * FROM Table ORDER BY field1

Table.sort(field1)

SELECT * FROM Table ORDER BY field1 DESC

Table.sort(-field1)

SELECT * FROM Table LIMIT 0, 20

Table[0..20]

SELECT * FROM Table
WHERE field1 = "value1"
    AND field2 < 100
ORDER BY field2 DESC
LIMIT 10, 20

Table.filter(field1 == "value1" && field2 < 100)
    .sort(-field2)[10..20]

INSERT INTO Table(field1, field2) VALUES("value1", 55)

Table {
    field1: "value1",
    field2: 55,
};
 table.insert()

UPDATE Table SET field1 = "value1", field2 = 55 WHERE id = 1

Table.get(1).update(field1 = "value1", field2 = 55);
// ou
Table.filter(id == 1).update(field1 = "value1", field2 = 55);
// ou
let table = Table.get(1);
table.field1 = "value1";
table.field2 = 55;
table.update();

DELETE FROM Table WHERE id = 1

Table.get(1).delete();
// ou
Table.filter(id == 1).delete()

SELECT AVG(field2) FROM Table

Table.aggregate(avg(field2))

SELECT AVG(field1) FROM Table1 GROUP BY field2

Table1.values(field2).annotate(avg(field1))

SELECT AVG(field1) as average FROM Table1
GROUP BY field2
HAVING average > 5

Table1.values(field2).annotate(average = avg(field1))
    .filter(average > 5)

SELECT AVG(field1) as average FROM Table1
WHERE field1 < 10
GROUP BY field2
HAVING average > 5

Table1.filter(field1 < 10).values(field2)
    .annotate(average = avg(field1)).filter(average > 5)

SELECT Table1.field1, Table2.field1 FROM Table1
INNER JOIN Table2 ON Table1.pk = Table2.fk

#[sqltable]
struct Table1 {
    pk: db::PrimaryKey,
    field1: i32,
}
#[sqltable]
struct Table2 {
    field1: i32,
    fk: db::ForeignKey,
}
Table1.all().join(Table2)

SELECT * FROM Table1 WHERE YEAR(date) = 2015

Table1.filter(date.year() == 2015)

SELECT * FROM Table1 WHERE INSTR(field1, 'string') > 0

Table1.filter(field1.contains("string"))

SELECT * FROM Table1 WHERE field1 in (1, 2, 3)

Table1.filter([1, 2, 3].contains(field1))

SELECT * FROM Table1 WHERE field1 LIKE 'string%'

Table1.filter(field1.startswith("string"))

SELECT * FROM Table1 WHERE field1 LIKE '%string'

Table1.filter(field1.endswith("string"))

SELECT * FROM Table1 WHERE field1 BETWEEN 1 AND 5

Table1.filter(field1 in 1..6)

SELECT * FROM Table1 WHERE field1 IS NULL

Table1.filter(field1.isnone())

SELECT * FROM Table1 WHERE field1 REGEXP BINARY '\^[a-d]'

Table1.filter(r"\^[a-d]".ismatch(field1))

SELECT * FROM Table1 WHERE field1 REGEXP '\^[a-d]'

Table1.filter(r"\^[a-d]".ismatch(field1, db::CaseInsensitive))

CREATE TABLE IF NOT EXISTS Table1 (
    pk INTEGER NOT NULL AUTOINCREMENT,
    field1 INTEGER,
    PRIMARY KEY (pk)
)

#[sql_table]
struct Table1 {
    pk: db::PrimaryKey,
    field1: i32,
}
Table1.create()