Expand and linearly interpolate values for in between integers across groups using SQL
I have a table which has a value column, multiple columns on which to group and an “index” column which consists of integer values that are not contiguous. I want to expand the table by adding all missing intermediate indices for each group and linearly interpolate the value from the closest higher and lower value within each group