[sql_database] generates correct sort order sql

[rudolfix]

Tell us what you do here

sort order was generated without takin last_value_func into account, this PR corrects that and adds tests