Support for BigInt for Long columns?

[saibotsivad]

Looking through the code, I see intColumn which says "use to insert LONG" but, unless I'm missing something, we need to use BigInt to support LONG columns:

-   intColumn(name: string, value: number): Sender {
+   intColumn(name: string, value: bigint): Sender {

I dug far enough that I believe I could put a PR together, but wanted to make sure I wasn't missing something.

[glasstiger]

Hi @saibotsivad,

You are correct, Javascript's number type (Number.MAX_SAFE_INTEGER) does not cover the full range of QuestDB's LONG datatype, which corresponds to Java's long.
The DECIMAL type introduced in v3 would address this gap, and that API already accepts bigint values.

That said, I think it would be a worthwhile improvement to accept bigint values in intColumn().
I would still keep support for the number type too:

intColumn(name: string, value: number | bigint): Sender {

If nothing else, we should keep it for backwards compatibility.

If you are interested, you are very welcome to open a PR for this change.
Thank you.