I may have missed it, but is there a way to see the SQL that is generated?
Yes, please refer to the LLBLGen Pro documentation "Using the generated code -> Troubleshooting and debugging"