Docs.rs
  • sqlparser-queryscript-0.30.0
    • sqlparser-queryscript 0.30.0
    • Docs.rs crate page
    • Apache-2.0
    • Links
    • Homepage
    • Repository
    • crates.io
    • Source
    • Owners
    • ankrgyl
    • Dependencies
      • bigdecimal ^0.3 normal
      • log ^0.4 normal
      • serde ^1.0 normal
      • serde_json ^1.0 normal
      • sqlparser_derive ^0.1.1 normal
      • matches ^0.1 dev
      • pretty_assertions ^1 dev
      • simple_logger ^4.0 dev
    • Versions
    • 20.75% of the crate is documented
  • Go to latest version
  • Platform
    • i686-pc-windows-msvc
    • i686-unknown-linux-gnu
    • x86_64-apple-darwin
    • x86_64-pc-windows-msvc
    • x86_64-unknown-linux-gnu
  • Feature flags
  • docs.rs
    • About docs.rs
    • Privacy policy
  • Rust
    • Rust website
    • The Book
    • Standard Library API Reference
    • Rust by Example
    • The Cargo Guide
    • Clippy Documentation
logo

Crate sqlparser

logo

Crate sqlparser

  • Version 0.30.0
  • All Items
  • Modules

Crates

  • sqlparser
?
Change settings

Crate sqlparser

source ·
Expand description

SQL Parser for Rust

This crate provides an ANSI:SQL 2011 lexer and parser that can parse SQL into an Abstract Syntax Tree (AST). See the sqlparser crates.io page for more information.

See Parser::parse_sql and Parser::new for the Parsing API and the ast crate for the AST structure.

Example:

use sqlparser::dialect::GenericDialect;
use sqlparser::parser::Parser;

let dialect = GenericDialect {}; // or AnsiDialect

let sql = "SELECT a, b, 123, myfunc(b) \
           FROM table_1 \
           WHERE a > b AND b < 100 \
           ORDER BY a DESC, b";

let ast = Parser::parse_sql(&dialect, sql).unwrap();

println!("AST: {:?}", ast);

Modules

ast
SQL Abstract Syntax Tree (AST) types
dialect
keywords
This module defines
location
parser
SQL Parser
tokenizer
SQL Tokenizer

Results

sqlparser::ast::Visitor
A visitor that can be used to walk an AST tree.
sqlparser::ast::VisitorMut
A visitor that can be used to mutate an AST tree.
sqlparser::ast::Visit
A type that can be visited by a Visitor. See Visitor for …
sqlparser::ast::Visit::visit
sqlparser::ast::VisitMut::visit
sqlparser::ast::DataType::visit
sqlparser::ast::TimezoneInfo::visit
sqlparser::ast::ExactNumberInfo::visit
sqlparser::ast::CharacterLength::visit
sqlparser::ast::CharLengthUnits::visit
sqlparser::ast::AlterTableOperation::visit
sqlparser::ast::AlterIndexOperation::visit
sqlparser::ast::AlterColumnOperation::visit
sqlparser::ast::TableConstraint::visit
sqlparser::ast::KeyOrIndexDisplay::visit
sqlparser::ast::IndexType::visit
sqlparser::ast::ColumnDef::visit
sqlparser::ast::ColumnOptionDef::visit
sqlparser::ast::ColumnOption::visit
sqlparser::ast::ReferentialAction::visit
sqlparser::ast::UnaryOperator::visit
sqlparser::ast::BinaryOperator::visit
sqlparser::ast::Query::visit
sqlparser::ast::SetExpr::visit
sqlparser::ast::SetOperator::visit
sqlparser::ast::SetQuantifier::visit
sqlparser::ast::Table::visit
sqlparser::ast::Select::visit
sqlparser::ast::LateralView::visit
sqlparser::ast::With::visit
sqlparser::ast::Cte::visit
sqlparser::ast::SelectItem::visit
sqlparser::ast::IdentWithAlias::visit
sqlparser::ast::WildcardAdditionalOptions::visit
sqlparser::ast::ExcludeSelectItem::visit
sqlparser::ast::RenameSelectItem::visit
sqlparser::ast::ExceptSelectItem::visit
sqlparser::ast::TableWithJoins::visit
sqlparser::ast::TableFactor::visit
sqlparser::ast::TableAlias::visit
sqlparser::ast::Join::visit
sqlparser::ast::JoinOperator::visit
sqlparser::ast::JoinConstraint::visit
sqlparser::ast::OrderByExpr::visit
sqlparser::ast::Offset::visit
sqlparser::ast::OffsetRows::visit
sqlparser::ast::Fetch::visit
sqlparser::ast::LockClause::visit
sqlparser::ast::LockType::visit
sqlparser::ast::NonBlock::visit
sqlparser::ast::Top::visit
sqlparser::ast::Values::visit
sqlparser::ast::SelectInto::visit
sqlparser::ast::Value::visit
sqlparser::ast::DollarQuotedString::visit
sqlparser::ast::DateTimeField::visit
sqlparser::ast::TrimWhereField::visit
sqlparser::ast::Ident::visit
sqlparser::ast::ObjectName::visit
sqlparser::ast::Array::visit
sqlparser::ast::JsonOperator::visit
sqlparser::ast::Expr::visit
sqlparser::ast::WindowSpec::visit
sqlparser::ast::WindowFrame::visit
sqlparser::ast::WindowFrameUnits::visit
sqlparser::ast::WindowFrameBound::visit
sqlparser::ast::AddDropSync::visit
sqlparser::ast::ShowCreateObject::visit
sqlparser::ast::CommentObject::visit
sqlparser::ast::Password::visit
sqlparser::ast::Statement::visit
sqlparser::ast::SequenceOptions::visit
sqlparser::ast::MinMaxValue::visit
sqlparser::ast::OnInsert::visit
sqlparser::ast::OnConflict::visit
sqlparser::ast::ConflictTarget::visit
sqlparser::ast::OnConflictAction::visit
sqlparser::ast::DoUpdate::visit
sqlparser::ast::Privileges::visit
sqlparser::ast::FetchDirection::visit
sqlparser::ast::Action::visit
sqlparser::ast::GrantObjects::visit
sqlparser::ast::Assignment::visit
sqlparser::ast::FunctionArgExpr::visit
sqlparser::ast::FunctionArg::visit
sqlparser::ast::CloseCursor::visit
sqlparser::ast::Function::visit
sqlparser::ast::AnalyzeFormat::visit
sqlparser::ast::FileFormat::visit
sqlparser::ast::ListAgg::visit
sqlparser::ast::ListAggOnOverflow::visit
sqlparser::ast::ArrayAgg::visit
sqlparser::ast::ObjectType::visit
sqlparser::ast::KillType::visit
sqlparser::ast::HiveDistributionStyle::visit
sqlparser::ast::HiveRowFormat::visit
sqlparser::ast::HiveIOFormat::visit
sqlparser::ast::HiveFormat::visit
sqlparser::ast::SqlOption::visit
sqlparser::ast::TransactionMode::visit
sqlparser::ast::TransactionAccessMode::visit
sqlparser::ast::TransactionIsolationLevel::visit
sqlparser::ast::ShowStatementFilter::visit
sqlparser::ast::SqliteOnConflict::visit
sqlparser::ast::CopyTarget::visit
sqlparser::ast::OnCommit::visit
sqlparser::ast::CopyOption::visit
sqlparser::ast::CopyLegacyOption::visit
sqlparser::ast::CopyLegacyCsvOption::visit
sqlparser::ast::MergeClause::visit
sqlparser::ast::DiscardObject::visit
sqlparser::ast::ContextModifier::visit
sqlparser::ast::DropFunctionDesc::visit
sqlparser::ast::OperateFunctionArg::visit
sqlparser::ast::ArgMode::visit
sqlparser::ast::FunctionBehavior::visit
sqlparser::ast::FunctionDefinition::visit
sqlparser::ast::CreateFunctionBody::visit
sqlparser::ast::CreateFunctionUsing::visit
sqlparser::ast::SchemaName::visit
sqlparser::ast::SearchModifier::visit
sqlparser::ast::helpers::stmt_create_table::CreateTableBuilder::visit
sqlparser::keywords::Keyword::visit
sqlparser::tokenizer::Token::visit
sqlparser::tokenizer::Word::visit
sqlparser::tokenizer::Whitespace::visit
No results :(
Try on DuckDuckGo?

Or try looking in one of these:
  • The Rust Reference for technical details about the language.
  • Rust By Example for expository code examples.
  • The Rust Book for introductions to language features and the language itself.
  • Docs.rs for documentation of crates released on crates.io.
No results :(
Try on DuckDuckGo?

Or try looking in one of these:
  • The Rust Reference for technical details about the language.
  • Rust By Example for expository code examples.
  • The Rust Book for introductions to language features and the language itself.
  • Docs.rs for documentation of crates released on crates.io.