SQL AS how to do with OrmLite

[mythz]

No specific API that does it, you’d just need to concatenate the SQL expressions:

Union all support in ServiceStack ORM lite 4.5.4

Whilst it’s not supported yet, you should be able to construct it with something like: var sql = query1.ToSelectStatement() + " UNION ALL " + query2.ToSelectStatement(); var results = db.SqlList<Notice>(sql);