use crate::column_types::models::Warehouse;
use crate::write_sql::_helpers::identifiers::{qualified, quote};
use crate::write_sql::models::TableName;
pub fn loaded_files_query(
table: &TableName,
file_column: &str,
version_column: Option<&str>,
warehouse: Warehouse,
) -> String {
let file = quote(file_column, warehouse);
let expression = match version_column {
Some(version) => format!(
"{file} || '|' || COALESCE({}, '')",
quote(version, warehouse)
),
None => file,
};
format!(
"SELECT DISTINCT {expression} FROM {}",
qualified(table, warehouse)
)
}