Are stored procedures supported?

Yes. Execute a stored procedure in a Native SQL Query using the EXEC syntax for Microsoft SQL Server:

EXEC dbo.uspGetEmployeeManagers @EmployeeID = 6;
GO