No, it cannot be used to create geometry. It can make minor corrections to geometry errors, but nothing much more other than translations and scaling.
You can use it with a number of other FDM printers, but I think currently the only DLP based SLA printer you can use it with is the Ember, for now. That will change when further updates are released in upcoming months or within the year. The Ember and its corresponding software are very new at the moment. Just a year or two old. Autodesk has been releasing open source updates veryyyyy slowlyyyyyy so that's why the ability to use the software with other 3D printers is limited.
This software is called slicing software. The software slices a 3D model into layers so that each layer can be printed by the 3D printer. This kind of software also generates support structures built into the layers so that the layers can be printed properly; for example there is no way to print in mid air so supports must be made so this kind of geometry can be created. Well, you could do it in zero gravity, but zero gravity is hard to come by.
Oh and, I should tell you that some 3D printing processes don't need supports at all because the base material is a powder. For more about that look into SLS (Selective Laser Sintering), DMLS (Direct Metal Laser Sintering) and 3D Metal to name a few of them.
In addition to slicing and generating supports a lot of slicers also control the functions of 3D printers in real time during the printing process. Like controlling linear motion, maintaining temperatures, activating light beams and lasers and so on. Also too, a lot of 3D printers can get all of their instructions for creating a 3D print on a flash drive so that the printer can print by itself without having any real time instructions from the slicer software.