ex.convert(b"\x00\x00\x00\x00\x00\x00\x07\xd3") throws, but should be HexString

[aersam]

The behavior of binary literal's is a bit weird currently:

import sqlglot.expressions as ex
import sqlglot as sg

print(
    repr(sg.parse_one("select 0x00000000000007d3", dialect="tsql"))
)  # binary literal in SQL Server
print(
    sg.parse_one("select 0x00000000000007d3", dialect="tsql").sql("duckdb")
)  # SELECT 2003 --> it's an int in duckdb, a bit unfortunate

import duckdb

duckdb.execute(
    "select '0x00000000000007d3'::blob"
).fetchall()  # correctly gives [(b'0x00000000000007d3',)]

ex.convert(
    b"\x00\x00\x00\x00\x00\x00\x07\xd3"
)  # should be ex.HexString(this="0x00000000000007d3"), I guess
# currently throws

Maybe a dedicated BinaryLiteral Type would be good? Not sure how to solve this :)

[georgesittas]

How would you go from b"\x00\x00\x00\x00\x00\x00\x07\xd3" to "0x00000000000007d3"?

[georgesittas]

I guess using something like "0x" + b"\x00\x00\x00\x00\x00\x00\x07\xd3".hex()?