Yes, this option is available from various connectors as well as directly from the Firebolt Python SDK.
As mentioned in SDK docs:
If the engine is not specified, your default engine is used.
If you are working directly from the API, you can instead follow these steps:
Retrieve the default engine URL with this request -
curl --request GET 'https://api.app.firebolt.io/core/v1/account/engines:getURLByDatabaseName?database_name=YOUR_DATABASE_NAME' \
--header 'Authorization: Bearer YOUR_ACCESS_TOKEN_VALUE'
Send the request to the engine by using the retrieved URL.