You could do:
SELECT ... FROM tbl WHERE datefromparts(_year, _month, _day) = '2023-08-12'
Although this will not make use of any indexes, so it will be a full scan of the table, which is not fun if the table is big.
An alternative is to add a computed column:
date AS datefromparts(_year, _month, _day)
and then index that column and use it the queries.