Enum DatabaseType 

pub enum DatabaseType {
    PostgreSQL,
}

Database types supported by FraiseQL.

FraiseQL is PostgreSQL-only: the MySQL, SQLite and SQL Server variants were removed with their adapters (G2 decision on #374 — the non-PostgreSQL dialects were never production-correct, see #721/#799). The enum is kept — rather than replaced with a unit type — so that SQL-generation seams stay explicitly tagged with the dialect they emit, and a future backend addition is a compile-time-visible change at every match site.

Stability

This enum is intentionally not #[non_exhaustive]. All match sites in the codebase must handle every variant explicitly, giving compile-time assurance that new database backends are fully integrated before release. Adding a variant is a semver-breaking change (minor version bump with migration guide).

Variants

PostgreSQL

PostgreSQL database (the only supported backend).

Implementations

impl DatabaseType

pub fn json_field_expr(self, key: &str) -> String

Return a SQL expression that extracts a text value from the data JSONB column.

The key must already be validated via OrderByClause::validate_field_name and converted to snake_case storage form via OrderByClause::storage_key.

Examples

use fraiseql_db::DatabaseType;

assert_eq!(DatabaseType::PostgreSQL.json_field_expr("created_at"), "data->>'created_at'");

pub fn dialect(self) -> &'static dyn SqlDialect

Return the SqlDialect that renders SQL for this database.

The two dialect abstractions — this enum, used by the ORDER BY renderer, and the SqlDialect trait, used by the WHERE generator — resolve to the same implementation here, so neither can carry its own copy of a rendering rule.

pub fn typed_json_field_expr( self, key: &str, field_type: ScalarFieldType, ) -> String

Return a SQL expression that extracts and casts a value from the data JSONB column for ORDER BY sorting.

When field_type is ScalarFieldType::Text this is identical to json_field_expr. For numeric, date, and boolean types the expression is wrapped in a dialect-specific cast so the database sorts by the typed value instead of the raw text ("9" > "10" is wrong for numbers).

The cast itself comes from SqlDialect::cast_expr_as — the same call the WHERE generator makes — so an ORDER BY and a filter on one field agree.

Examples

use fraiseql_db::{DatabaseType, ScalarFieldType};

assert_eq!(
    DatabaseType::PostgreSQL.typed_json_field_expr("amount", ScalarFieldType::Numeric),
    "(data->>'amount')::numeric"
);

impl DatabaseType

pub const fn as_str(&self) -> &'static str

Get database type as string.

Trait Implementations

impl Clone for DatabaseType

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Copy for DatabaseType

impl Debug for DatabaseType

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for DatabaseType

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for DatabaseType

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

Formats the value using the given formatter.

impl Eq for DatabaseType

impl Hash for DatabaseType

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl PartialEq for DatabaseType

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

Equality operator ==.

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

Inequality operator !=.

impl Serialize for DatabaseType

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for DatabaseType