Insert query format customization

[retrogemHK]

I want to sink data via insert query like below.

INSERT INTO jordy(user_id, message) SELECT 10, saleDate AS aa FROM sale_date LIMIT 1;

But insert query format like this

INSERT INTO %s VALUES %s

How can I customize insert query?