xorm | Simple and Powerful ORM for Go, support mysql,postgres,tidb,sqlite3,mssql,oracle, Moved to https://g | SQL Database library

Then all place where engine you can just use engineGroup.
Create Engine
Define a struct and Sync2 table struct to database
Create Engine Group
Query runs a SQL string, the returned results is []map[string][]byte, QueryString returns []map[string]string, QueryInterface returns []map[string]interface{}.
Exec runs a SQL string, it returns affected and error
Insert one or multiple records to database
Get query one record from database
Exist check if one record exist on table
Find query multiple records from database, also you can use join and extends
Iterate and Rows query multiple records and record by record handle, there are two methods Iterate and Rows
Update update one or more records, default will update non-empty and non-zero fields except when you use Cols, AllCols and so on.
Delete delete one or more records, Delete MUST have condition
Count count records
FindAndCount combines function Find with Count which is usually used in query by page
Sum sum functions
Query conditions builder
Multiple operations in one go routine, no transation here but resue session memory
Transation should on one go routine. There is transaction and resue session memory
Or you can use Transaction to replace above codes.
Context Cache, if enabled, current query result will be cached on session and be used by next same statement on the same session.