athena_cli::validation

Function validate_query_syntax

Source 
pub fn validate_query_syntax(query: &str) -> Result<()>
Expand description

Validates the syntax of an Athena SQL query.

This function uses the sqlparser crate to parse the query using ANSI SQL standards, which is compatible with Athena’s SQL syntax. It returns a Result that indicates whether the query syntax is valid.

§Arguments

  • query - The SQL query string to validate

§Returns

  • Ok(()) if the query syntax is valid
  • Err(anyhow::Error) with a descriptive error message if the syntax is invalid

§Examples

use athena_cli::validation::validate_query_syntax;

// Valid query
let valid_query = "SELECT * FROM my_table WHERE id = 1";
assert!(validate_query_syntax(valid_query).is_ok());

// Invalid query with trailing comma
let invalid_query = "SELECT id, FROM my_table";
assert!(validate_query_syntax(invalid_query).is_err());