SQL.unsafe method | Bun module | Bun

If you know what you're doing, you can use unsafe to pass any string you'd like. Please note that this can lead to SQL injection if you're not careful. You can also nest sql.unsafe within a safe sql expression. This is useful if only part of your fraction has unsafe elements.

const result = await sql.unsafe(`select ${danger} from users where id = ${dragons}`)

Represents a SQL query that can be executed, with additional control methods Extends Promise to allow for async/await usage

Indicates if the query is currently executing

Indicates if the query has been cancelled

Cancels the executing query

Attaches a callback for only the rejection of the Promise.

The callback to execute when the Promise is rejected.

A Promise for the completion of the callback.

Executes the query

Attaches a callback that is invoked when the Promise is settled (fulfilled or rejected). The resolved value cannot be modified from the callback.

The callback to execute when the Promise is settled (fulfilled or rejected).

A Promise for the completion of the callback.

Returns the raw query result

Executes the query as a simple query, no parameters are allowed but can execute multiple commands separated by semicolons

Attaches callbacks for the resolution and/or rejection of the Promise.

The callback to execute when the Promise is resolved.

The callback to execute when the Promise is rejected.

A Promise for the completion of which ever callback is executed.

Returns only the values from the query result