Yes, you could create a base view from query following the next steps:
* Open the datasource that connects to the MS SQL Server
* Click on "Create base view"
* Click on "Create from query"
* Give a name to the view a write the query using the [join hint for MS SQL Server](https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-join)
FROM Product AS p
LEFT OUTER HASH JOIN ProductReview AS pr
ON p.ProductID = pr.ProductID;
Now, the base the base view is created and it will be executed executing the hash join in MS SQL Server.
Hope this helps!