osirisdb 0.4.0

A SQL database engine built from scratch in Rust featuring a custom parser, binder, query planner, optimizer, catalog, and storage engine.
Documentation 
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

use crate::ast::*;

/// Represents an explicit join clause in a `SELECT` statement (e.g. `LEFT JOIN orders ON users.id = orders.user_id`).
#[derive(Debug, Clone, PartialEq)]
pub struct JoinClause {
    /// The join type (e.g., `INNER`, `LEFT OUTER`, `CROSS`).
    pub join_type: JoinType,
    /// The right-hand side table reference being joined.
    pub table: TableRef,
    /// The filter condition representing the `ON` clause. Unused for `CROSS JOIN`.
    pub condition: Option<Expr>,
}

/// The type of join to perform.
#[derive(Debug, Clone, PartialEq)]
pub enum JoinType {
    /// Standard inner join matching rows in both tables (`INNER JOIN`).
    Inner,
    /// Left outer join returning all rows from the left table and matched rows from the right table (`LEFT [OUTER] JOIN`).
    Left,
    /// Right outer join returning all rows from the right table and matched rows from the left table (`RIGHT [OUTER] JOIN`).
    Right,
    /// Full outer join returning all rows when there is a match in either left or right table (`FULL [OUTER] JOIN`).
    Full,
    /// Cartesian product of both tables (`CROSS JOIN`).
    Cross,
}