I'm not aware of such issues. Is your IQueryable DbContext DbSet or something custom? As far as I know the DataGrid can page and filter by dates normally with Microsoft SQL Server, MySQL, PostgreSQL and SQLite DbSets.
Our demos for example with SQLite:
https://github.com/akorchev/blazor.radzen.com/blob/master/Data/NorthwindContext.cs