How to use SQL with MongoDb to create custom columns in metabase v1.46.2

To create a custom column, can I use SQL code to write the functions? Whenever I write SQL code in the edior it shows an error "JSON reader was expecting a value but found 'ALTER".
So, my questions are
1- How to create custom columns in Metabase using basic SQL queries with MongoDB on Metabase v1.46.2
2- Where can i create multiple columns using different functions, do i have to select the new->model->Native Query->select db->write the code or is there any other way?


  1. just write the custom columns with MongoQL in a native question as you would do with a mongo client
  2. you could make those with the GUI builder, so instead of using native mode, you could just create a custom column in the normal question mode