With SQL Server 2016, that is no longer a problem. Implementation Row-Level Security in SQL Server 2016 (and SQL Azure) is based on a specially crafted inline table valued function.

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...