We have to manually add to the sql 2016 and sql 2019 capabilities files.
#RIGHT
RIGHT(~date,~string): RIGHT($1, $2)
RIGHT(@null,~string): RIGHT($1, $2)
RIGHT(~number,~string): RIGHT($1, $2)
RIGHT(~number,@null): RIGHT($1, $2)
RIGHT(~any,~any,): RIGHT($1, $2)
RIGHT(@timestamp,~string): RIGHT($1, $2)
RIGHT(~string,~number): RIGHT($1,CONVERT(BIGINT, $2))
RIGHT(~string,~whole_number) : RIGHT($1, $2)
