// current implementation
func (h *ApiKeyServiceHandler) GetAPIKey(ctx context.Context, req *connect.Request[sdp.GetAPIKeyRequest]) (*connect.Response[sdp.GetAPIKeyResponse], error) {
	// skipped authorization code
	databaseKey, err := h.Queries.GetApiKeyByID(ctx, models.GetApiKeyByIDParams{
		ExternalID: id,
		AccountName: claims.AccountName,
	})
	// skipped error handling
	resp := connect.NewResponse(&sdp.GetAPIKeyResponse{
		Key: databaseKey.ToSDP(),
	})
	return resp, nil
}
// ApiKey is the generated model from sqlc
func (k *ApiKey) ToSDP() *sdp.APIKey {
	result := &sdp.APIKey{
		Metadata: &sdp.APIKeyMetadata{
			Uuid: k.ExternalID[:],
			Created: &k.CreatedAt,
			LastUsed: k.LastUsed,
			Key: k.Key,
			Scopes: k.Scopes,
			Status: sdp.KeyStatus(k.Status),
		},
		Properties: &sdp.APIKeyProperties{
			Name: k.Name,
		},
	}
	if k.Error.Valid {
		result.Metadata.Error = k.Error.String
	}
	return result
}

-- name: GetApiKeyByID :one
SELECT *
FROM api_keys
WHERE account_name = @account_name
 and external_id = @external_id;

-- name: GetApiKeyByID :one :go:result:*sdp.APIKey
SELECT *
FROM api_keys
WHERE account_name = @account_name
 and external_id = @external_id;

// current implementation
func (h *ApiKeyServiceHandler) GetAPIKey(ctx context.Context, req *connect.Request[sdp.GetAPIKeyRequest]) (*connect.Response[sdp.GetAPIKeyResponse], error) {
	// skipped authorization code
	databaseKey, err := h.Queries.GetApiKeyByID(ctx, models.GetApiKeyByIDParams{
		ExternalID: id,
		AccountName: claims.AccountName,
	})
	// skipped error handling
	resp := connect.NewResponse(&sdp.GetAPIKeyResponse{
		Key: databaseKey // pass object through directly
	})
	return resp, nil
}
// no ApiKey model generated, no manual copying required

func (q *Queries) GetApiKeyByID(ctx context.Context, arg GetApiKeyByIDParams) (*sdp.APIKey, error) {
	row := q.db.QueryRowContext(ctx, getApiKeyByID, arg.AccountName, arg.ExternalID)
	var externalId uuid.Uuid
	var accountName string
	// etc
	err := row.Scan(
		&externalID,
		&accountName,
		// etc
	)
	var i sdp.APIKey
	i.ExternalID = externalId
	i.AccountName = accountName
	// etc
	return &i, err
}