what Mathieu meant was to build the whole SQL statement dynamically inside of a business object script and then pass it to the request parameter of your SQL connector call which must then be left blank in the respective creation dialog field. Basically this will give you the option to treat the SQL statement like an input parameter instead of the request getting taken from the SQL tab of the creation dialog.
