oh - I use an SQL Database, that might be the reason that you don´t have the functionality there? (and I use v0.25 but I doubt they would change that in v0.27).
Can you build questions using SQL syntax rather than the query builder?
Mhm… seems like I do not have another choice. I’m able to switch to “SQL”, but the generated code is a bunch of JSON. Seems like I have to adhere to the weird (at least for me) MongoDB query syntax:
In fact you can add column using raw aggregation pipeline. If you click on “View the native query” you’ll see an aggregation pipeline. In any $project stage you can add your column like that:
[
…
{$project: {
…
customColumn: {$subtract: ["$column1", “$column2”]}
…
}}
]
I’d say it’s extremely cumbersome but it’s how MongoDB works