cloudos.sql_validate: Validate SQL Query

In cloudosR: 'Lifebit' Platform 'API' Client

Validate SQL Query

Description

Validates SQL syntax and references before execution.

Usage

cloudos.sql_validate(profilename = "", sql = "")

Arguments

profilename	Character. Name of the configured profile to use. If empty or NULL, uses the default profile.
sql	Character. SQL query to validate.

Value

List with validation results including isValid, tableReferences, and columnReferences.

Examples

## Not run: 
  # Validate a SQL query
  validation <- cloudos.sql_validate(
    profilename = "production",
    sql = "SELECT person_id FROM person WHERE year_of_birth >= 1960"
  )
  
  if (validation$isValid) {
    cat("SQL is valid\n")
    cat("Tables:", paste(validation$tableReferences, collapse = ", "), "\n")
  } else {
    cat("SQL is invalid:", validation$message, "\n")
  }

## End(Not run)

cloudosR documentation built on June 1, 2026, 5:07 p.m.