Struct LateralJoin 

pub struct LateralJoin {
    pub subquery: String,
    pub alias: String,
    pub join_type: LateralJoinType,
    pub condition: Option<String>,
}

A LATERAL join specification.

Fields

subquery: String

The subquery or function call.

alias: String

Alias for the lateral result.

join_type: LateralJoinType

Join type.

condition: Option<String>

Optional ON condition (for LEFT LATERAL).

Implementations

impl LateralJoin

pub fn new( subquery: impl Into<String>, alias: impl Into<String>, ) -> LateralJoinBuilder

Create a new LATERAL join.

pub fn to_postgres_sql(&self) -> String

Generate PostgreSQL LATERAL join.

pub fn to_mysql_sql(&self) -> String

Generate MySQL LATERAL join.

pub fn to_mssql_sql(&self) -> String

Generate MSSQL APPLY join.

pub fn to_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate SQL for database type.

Trait Implementations

impl Clone for LateralJoin

fn clone(&self) -> LateralJoin

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for LateralJoin

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for LateralJoin

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for LateralJoin

fn eq(&self, other: &LateralJoin) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for LateralJoin

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for LateralJoin

impl StructuralPartialEq for LateralJoin