Pre-purchase questions: Data Bridge/DataAssist abilities...

Does DataAssist support creating complex queries visually that include?

Multiple table joins
GroupBy
Aggragate functions
SubQueries
Derived tables

If not, is it possible to paste these complex queries into DataAssist or code view and yet everything work?
Are there any query limitations that DataAssist cannot handle?
FYI, I use Flyspeed Visual Query Builder to create queries, I want to know how to incorporate queries built there into DataAssist workflow.

Also, how are transactions handled in DataAssist?
How would this example of transferring $100 to another account be handled: Confirm that I have $100 in my account; Decrease my account by $100; Verify the decrease; Increase the amount of money in your account by $100; Verify that the increase worked.

Are all parts of the transaction reversible if one part fails?

Can I update/insert/delete records in multiple tables in a single transaction; if not what is the recommended process?

I have not found much for video's or doc's that explain DataAssists abilities in depth, do they exist somewhere?

Thanks,
Brent