{

m_table.clear();

m_rowid_columns = {"_rowid_"};

m_selected_columns.clear();

m_where.clear();

m_sort.clear();

{

if(m_where.empty() && m_global_where.empty())

return std::string();

std::string where = "WHERE ";

if(m_where.size())

{

for(auto i=m_where.cbegin();i!=m_where.cend();++i)

{

const auto it = findSelectedColumnByName(i->first);

std::string column = sqlb::escapeIdentifier(i->first);

if(it != m_selected_columns.cend() && it->selector != i->first)

column = it->selector;

where += column + " " + i->second + " AND ";

}

// Remove last ' AND '

where.erase(where.size() - 5);

}

if(m_global_where.size())

{

// Connect to previous conditions if there are any

if(m_where.size())

where += " AND ";

// For each condition

for(const auto& w : m_global_where)

{

where += "(";

// For each selected column

for(const auto& c : m_column_names)

{

const auto it = findSelectedColumnByName(c);

std::string column = sqlb::escapeIdentifier(c);

if(it != m_selected_columns.cend() && it->selector != column)

column = it->selector;

where += column + " " + w + " OR ";

}

// Remove last ' OR '

where.erase(where.size() - 4);

where += ") AND ";

}

// Remove last ' AND '

where.erase(where.size() - 5);

}

return where;

{

// Selector and display formats

std::string selector;

if (withRowid)

{

// We select the rowid data into a JSON array in case there are multiple rowid columns in order to have all values at hand.

// If there is only one rowid column, we leave it as is.

if(m_rowid_columns.size() == 1)

{

// As of SQLite 3.36 when selecting rowid from a view SQLite does not return NULL anymore but instead returns "rowid" and throws

// an error. To avoid that error (we don't actually care for the value of this column, so the value is not the issue here) we

// explicitly select NULL (without any quotes) here.

if(m_is_view && !hasCustomRowIdColumn())

selector = "NULL,";

else

selector = sqlb::escapeIdentifier(m_rowid_columns.at(0)) + ",";

} else {

selector += "sqlb_make_single_value(";

for(size_t i=0;i<m_rowid_columns.size();i++)

selector += sqlb::escapeIdentifier(m_rowid_columns.at(i)) + ",";

selector.pop_back(); // Remove the last comma

selector += "),";

}

}

if(m_selected_columns.empty())

{

selector += "*";

} else {

for(const auto& it : m_selected_columns)

{

if (it.original_column != it.selector)

selector += it.selector + " AS " + sqlb::escapeIdentifier(it.original_column) + ",";

else

selector += sqlb::escapeIdentifier(it.original_column) + ",";

}

selector.pop_back();

}

// Filter

std::string where = buildWherePart();

// Sorting

std::string order_by;

for(const auto& sorted_column : m_sort)

order_by += sorted_column.toSql() + ",";

if(order_by.size())

{

order_by.pop_back();

order_by = "ORDER BY " + order_by;

}

return "SELECT " + selector + " FROM " + m_table.toString() + " " + where + " " + order_by;

{

// Build simplest count query for this (filtered) table

return "SELECT COUNT(*) FROM " + m_table.toString() + " " + buildWherePart();

{

return std::find_if(m_selected_columns.begin(), m_selected_columns.end(), [name](const SelectedColumn& c) {

return name == c.original_column;

});

{

return std::find_if(m_selected_columns.cbegin(), m_selected_columns.cend(), [name](const SelectedColumn& c) {

return name == c.original_column;

});