[query] Implement `ALTER`

[karasakalmt]

Write the function to simulate ALTER query between first and last state