Unable to execute union with order by expression

[o1egl]

Currently when I try to scan sql queries with union and order statements I receive goqu: unable to execute query did you use goqu.Database#From to create the dataset. Sql queries without order statement work as expected.

To Reproduce

db := goqu.New("postgres", conn)
sql := db.Select("id").From("table").Order(goqu.C("id").Asc()).
    Union(
        db.Select("id").From("table").Order(goqu.C("id").Asc()),
    )

var i []int
if err := sql.ScanValsContext(ctx, &i); err != nil {
    panic(err)
}

Dialect:

• postgres
• mysql
• sqlite3

Additional context
Currently I have found a workaround by wrapping the entire query with a select statement

db := goqu.New("postgres", conn)
sql := db.Select("id").From("table").Order(goqu.C("id").Asc()).
    Union(
        db.Select("id").From("table").Order(goqu.C("id").Asc()),
    )
// workaround
sql = db.Select("*").From(sql)
var i []int
if err := sql.ScanValsContext(ctx, &i); err != nil {
    panic(err)
}