One View Reporting - creating a new data model

Hello,

I have 2 questions regarding One View Reporting and creating a new data model from a MS SQL database:-

1).  In the Data model, Data Sets I use SQL Query, do I have to use the 'Query Builder' GUI and the SQL that is returned or can I type my own SQL statement?    The SQL returned from the 'Query Builder' GUI is different syntax from how I would write it but this could be because we're using a MS SQL database.

2).  Can you call a MS SQL Stored Procedure from the Data Model and use fields returned in a report?

Thanks,