Simple Query

ExampleBQL1.cs

private INSite GetSite(string siteCD)
{ 
    var siteQ = new SelectFrom<INSite>.Where<Use<INSite.siteCD>.AsString.IsEqual<@P.AsString>>.View(Base);      
    return siteQ.Select(siteCD).FirstOrDefault()
}

ExampleBQL1.sql

SELECT 
 [INSite].[SiteID], [INSite].[SiteCD], [INSite].[Descr], [INSite].[ReasonCodeSubID], [INSite].[SalesAcctID], [INSite].[SalesSubID], [INSite].[InvtAcctID], [INSite].[InvtSubID], [INSite].[COGSAcctID], [INSite].[COGSSubID], [INSite].[StdCstRevAcctID], [INSite].[StdCstRevSubID], [INSite].[StdCstVarAcctID], [INSite].[StdCstVarSubID], [INSite].[PPVAcctID], [INSite].[PPVSubID], [INSite].[POAccrualAcctID], [INSite].[POAccrualSubID], [INSite].[LCVarianceAcctID], [INSite].[LCVarianceSubID], [INSite].[ReceiptLocationID], [INSite].[ShipLocationID], [INSite].[DropShipLocationID], [INSite].[ReturnLocationID], [INSite].[LocationValid], [INSite].[BranchID], [INSite].[BAccountID], [INSite].[BaseCuryID], [INSite].[AddressID], [INSite].[ContactID], [INSite].[BuildingID], [INSite].[NoteID], NULL, NULL, NULL, [INSite].[ReplenishmentClassID], [INSite].[AvgDefaultCost], [INSite].[FIFODefaultCost], [INSite].[OverrideInvtAccSub], [INSite].[Active], [INSite].[CreatedByID], [INSite].[CreatedByScreenID], [INSite].[CreatedDateTime], [INSite].[LastModifiedByID], [INSite].[LastModifiedByScreenID], [INSite].[LastModifiedDateTime], [INSite].[tstamp], [INSite].[GroupMask], [INSite].[UseItemDefaultLocationForPicking], [INSite].[CarrierFacility]
FROM [INSite] [INSite]
WHERE ( [INSite].[CompanyID] = 2) 
 AND  ( [INSite].[BranchID] IS NULL  OR [INSite].[BranchID] IN ( 26, 25, 23)) 
 AND ( [INSite].[SiteCD] = @P0)
ORDER BY [INSite].[SiteCD] OPTION(OPTIMIZE FOR UNKNOWN)