How to transform data type when trying to find a match using Google Sheets query language

I'm trying to query for a specific row in a sheet by its content using this query in javascript:

const query = `SELECT * WHERE ${idColumn} = '${id}'`;

The problem is, sometimes the column seems to be a string, and sometimes it seems to be a number.
When a number, I would have to remove the single quotes from the id ${idColumn} = ${id}

The problem is that I don't know when the column is going to be a string or number,
I was hoping I could transform the data to string first.
Is that possible?

Something like:

const query = `SELECT * WHERE TO_TEXT(${jobIdColumn}) = '${jobId}'`

EDIT:
Here is an example file where column A is considered numbers by Google sheet, and column B is considered String:
https://docs.google.com/spreadsheets/d/1HYEuPr_1xqeCqL29ekuoSv1lZuVgfDUxpc8c1ZMYjUA/edit#gid=0

I can't use the same formula, to query both Columns,
I have to use single quotes on column B but none in column A

=QUERY(A1:B7,"SELECT A WHERE A = 5555    ",-1)
=QUERY(A1:B7,"SELECT A WHERE B = 'C5555' ",-1)

My Workaround right now is to use OR, but that doesn't seem right

SELECT * WHERE ${idColumn} = '${id}' OR ${idColumn} = ${id}

Although I'm not sure whether I could correctly understand your question, how about the following modification?

From:

const query = `SELECT * WHERE ${idColumn} = '${id}'`;

To:

const query = `SELECT * WHERE ${idColumn} = ${isNaN(id) ? `'${id}'` : Number(id)}`;

• By this modification, when id is a string, the value is enclosed by the single quotes. When id is a number, the value is not enclosed.
• In this case, it supposes that id is not null. Please be careful about this.

Testing:

<!-- begin snippet: js hide: true console: true babel: false -->

<!-- language: lang-js -->

const idColumn = "A";
["sample", 123].forEach(id => {
  const query = `SELECT * WHERE ${idColumn} = ${isNaN(id) ? `'${id}'` : Number(id)}`;
  console.log(query);
});

<!-- end snippet -->