Charlieface questions

Charlieface answers

• Joining SQL Temporal tables as-of time
• fill in missing data gaps in a table
• Populating generic object that is known to be an array at runtime
• Parse XML in SQL Server (with an array)
• Most efficient way to search by date in SQL Server database
• How to convert to and from DateTimeOffset and DateOnly?
• Deleting rows without overloading the database
• How to filter a query based on row number using LINQ with Entity Framework
• Nullable<long> is not Nullable<long> after assignment from long [duplicate]
• Does sqlite ignore WHERE clause after ON CONFLICT of UPSERT?