Your Question

var exists bool
sql = SELECT EXISTS(SELECT * FROM table WHERE aid = ? LIMIT 1)
err := db.Raw(sql, 123456).Row().Scan(&exists)

generate sql

SELECT EXISTS(SELECT * FROM table  WHERE aid = (123456) LIMIT 1)

Expected answer

SELECT EXISTS(SELECT * FROM table WHERE aid = 123456 LIMIT 1)