SQL Server Rowversion/Timestamp not parsed correctly

[aersam]

In MS SQL Server, there is a funny type called rowversion and has an alias timestamp. It has nothing in common with timestamp types in other databases. It's basically an binary(8) type which stores an incrementing number

https://learn.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-ver16

Sqlglot does not seem to recognize this type. It would be nice if sqlglot would transpile it correctly to binary types.

import sqlglot.expressions as ex
import sqlglot

print(  # transpiled type timestamp as is, should be binary
    sqlglot.parse_one("create table a (b timestamp)", dialect="tsql").sql("databricks")
)

print(  # prints ROWVERSION instead of BINARY
    sqlglot.parse_one("create table a (b rowversion)", dialect="tsql").sql("databricks")
)

print(  # good, this works! databricks timestamp is datetime2 in ms sql
    sqlglot.parse_one("create table a (b timestamp)", dialect="databricks").sql("tsql")
)

[aersam]

one more interesting side-effect:

print(  
    sqlglot.parse_one("create table a (b timestamp)", dialect="tsql").sql("tsql")  # prints datetime2, which is completely wrong here
)