use crate::bigquery_source::models::BigQueryReadRequest;
pub(crate) fn quote_identifier(name: &str) -> String {
format!("`{}`", name.replace('\\', "\\\\").replace('`', "\\`"))
}
pub(crate) fn select_query(project: &str, request: &BigQueryReadRequest<'_>) -> String {
let columns: Vec<&str> = request
.columns
.iter()
.map(|column| column.expression.as_str())
.collect();
let from = match request.sql {
Some(sql) => subquery(sql),
None => quote_identifier(&format!(
"{project}.{}.{}",
request.table.schema, request.table.name
)),
};
let filter = request
.filter
.map(|filter| format!(" WHERE {filter}"))
.unwrap_or_default();
format!("SELECT {} FROM {from}{filter}", columns.join(", "))
}
pub(crate) fn subquery(sql: &str) -> String {
let body = sql
.trim_start()
.trim_end_matches(|character: char| character == ';' || character.is_whitespace());
format!("({body}\n)")
}