queries.Raw(...) and CTE

[ColonelBlimp]

Hi,

I am struggling to execute a CTE and have my custom results struct populated. Any pointers would be much appreciated:

I have the following CTE:

WITH worked_status AS (
	SELECT band, mode, qso_date
	FROM qso
	WHERE call='XX1XX'
	)
	SELECT * FROM worked_status;

The above works from the database console (SQLite3).

type CallsignInfo struct {
	Band    string `boil:"band,bind"`
	Mode    string `boil:"mode,bind"`
	QsoDate string `boil:"qso_date,bind"`
}
type CallsignInfoSlice []*CallsignInfo

However, executing the following throws an error (panic):

	var info CallsignInfoSlice
	err := queries.Raw(
		`WITH callsign_worked_info AS (SELECT band, mode, qso_date FROM qso WHERE call = ?) SELECT * FROM callsign_worked_info`, call).Bind(context.Background(), d.exec, &info)

The generated Qso model looks like this:

type Qso struct {
	ID                 int64       `boil:"id" json:"id" toml:"id" yaml:"id"`
	CreatedAt          null.Time   `boil:"created_at" json:"created_at,omitempty" toml:"created_at" yaml:"created_at,omitempty"`
	DeletedAt          null.Time   `boil:"deleted_at" json:"deleted_at,omitempty" toml:"deleted_at" yaml:"deleted_at,omitempty"`
	ModifiedAt         null.Time   `boil:"modified_at" json:"modified_at,omitempty" toml:"modified_at" yaml:"modified_at,omitempty"`
	Call               string      `boil:"call" json:"call" toml:"call" yaml:"call"`
	StationCallsign    string      `boil:"station_callsign" json:"station_callsign" toml:"station_callsign" yaml:"station_callsign"`
	MyName             string      `boil:"my_name" json:"my_name" toml:"my_name" yaml:"my_name"`
	Band               string      `boil:"band" json:"band" toml:"band" yaml:"band"`
	Freq               string      `boil:"freq" json:"freq" toml:"freq" yaml:"freq"`
	Mode               string      `boil:"mode" json:"mode" toml:"mode" yaml:"mode"`
	QsoDate            string      `boil:"qso_date" json:"qso_date" toml:"qso_date" yaml:"qso_date"`
	RstRcvd            string      `boil:"rst_rcvd" json:"rst_rcvd" toml:"rst_rcvd" yaml:"rst_rcvd"`
	RstSent            string      `boil:"rst_sent" json:"rst_sent" toml:"rst_sent" yaml:"rst_sent"`
	TimeOn             string      `boil:"time_on" json:"time_on" toml:"time_on" yaml:"time_on"`
	RxPwr              null.String `boil:"rx_pwr" json:"rx_pwr,omitempty" toml:"rx_pwr" yaml:"rx_pwr,omitempty"`
	Comments           null.String `boil:"comments" json:"comments,omitempty" toml:"comments" yaml:"comments,omitempty"`
	Notes              null.String `boil:"notes" json:"notes,omitempty" toml:"notes" yaml:"notes,omitempty"`
	SessionID          int64       `boil:"session_id" json:"session_id" toml:"session_id" yaml:"session_id"`
	LogbookID          int64       `boil:"logbook_id" json:"logbook_id" toml:"logbook_id" yaml:"logbook_id"`
	ContactedStationID int64       `boil:"contacted_station_id" json:"contacted_station_id" toml:"contacted_station_id" yaml:"contacted_station_id"`

	R *qsoR `boil:"-" json:"-" toml:"-" yaml:"-"`
	L qsoL  `boil:"-" json:"-" toml:"-" yaml:"-"`
}

Could someone point me in the right direction as to how to populate the CallsignInfoSlice with data from the query?

Many thanks in advance.

[ColonelBlimp]

Apologies for disturbing everyone with this, it just required the boil:"..." tags being removed from the CallsignInfo struct