Another complex query example

example_dynamic_query.go

//select * from application a where a.created_at >= '2018-01-01' AND a.created_at <= '2019-01-01' AND a.id >=0 AND (a.status = 'some_status' OR a.id =2 )
func GenerateQuery(ctx context.Context, queryParams QueryParams) (query string) {
	var dqb DynamicQueryBuilder

	query = dqb.And(
		dqb.NewExp("a.created_at", ">=", queryParams["start_date"]+" "+queryParams["start_time"]), //if empty it will not be added in where clause
		dqb.NewExp("a.created_at", "<=", queryParams["end_date"]+" "+queryParams["end_time"]),
		"a.id >= 0",
		"a.status IN ('pending','complete','initiated')",
		dqb.OR(
			dqb.NewExp("a.status","=",queryParams["status"]),
			dqb.NewExp("a.id","=",queryParams.GetInt("id")),
		),
	).BindSql("select * from application a")

	return
}