Cardano Updates

Bumps [github.com/aws/aws-sdk-go-v2/credentials](https://github.com/aws/aws-sdk-go-v2) from 1.19.17 to 1.19.23.
- [Release notes](https://github.com/aws/aws-sdk-go-v2/releases)
- [Commits](https://github.com/aws/aws-sdk-go-v2/compare/credentials/v1.19.17...credentials/v1.19.23)

---
updated-dependencies:
- dependency-name: github.com/aws/aws-sdk-go-v2/credentials
  dependency-version: 1.19.22
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Bumps [github.com/aws/aws-sdk-go-v2/credentials](https://github.com/aws/aws-sdk-go-v2) from 1.19.17 to 1.19.23.
- [Release notes](https://github.com/aws/aws-sdk-go-v2/releases)
- [Commits](https://github.com/aws/aws-sdk-go-v2/compare/credentials/v1.19.17...credentials/v1.19.23)

---
updated-dependencies:
- dependency-name: github.com/aws/aws-sdk-go-v2/credentials
  dependency-version: 1.19.22
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [github.com/aws/aws-sdk-go-v2](https://github.com/aws/aws-sdk-go-v2) from 1.41.9 to 1.42.0.
- [Release notes](https://github.com/aws/aws-sdk-go-v2/releases)
- [Commits](https://github.com/aws/aws-sdk-go-v2/compare/v1.41.9...v1.42.0)

---
updated-dependencies:
- dependency-name: github.com/aws/aws-sdk-go-v2
  dependency-version: 1.41.12
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Signed-off-by: Akhil Repala <[email protected]>

Add usage examples and reference documentation for the Conway
governance (CIP-1694) local-state queries.

- Add drep-state, committee-state, proposals, and vote-delegatees
  subcommands to the examples/state-query CLI, alongside the existing
  local-state queries. Usage examples live under examples/ rather than
  in test files so they are easy to find without reading the test suite.
- Expand doc comments on all governance query methods (GetConstitution,
  GetGovState, GetDRepState, GetDRepStakeDistr, GetCommitteeMembersState,
  GetFilteredVoteDelegatees, GetSPOStakeDistr, GetProposals,
  GetRatifyState) to cover when to use each, the response structure, and
  the Conway-era requirement.

Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>
Signed-off-by: Chris Guiney <[email protected]>

Signed-off-by: Akhil Repala <[email protected]>

Bumps [github.com/aws/aws-sdk-go-v2](https://github.com/aws/aws-sdk-go-v2) from 1.41.9 to 1.42.0.
- [Release notes](https://github.com/aws/aws-sdk-go-v2/releases)
- [Commits](https://github.com/aws/aws-sdk-go-v2/compare/v1.41.9...v1.42.0)

---
updated-dependencies:
- dependency-name: github.com/aws/aws-sdk-go-v2
  dependency-version: 1.41.12
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [github.com/blinklabs-io/gouroboros](https://github.com/blinklabs-io/gouroboros) from 0.180.1 to 0.181.0.
- [Release notes](https://github.com/blinklabs-io/gouroboros/releases)
- [Changelog](https://github.com/blinklabs-io/gouroboros/blob/main/RELEASE_NOTES.md)
- [Commits](https://github.com/blinklabs-io/gouroboros/compare/v0.180.1...v0.181.0)

---
updated-dependencies:
- dependency-name: github.com/blinklabs-io/gouroboros
  dependency-version: 0.181.0
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [google.golang.org/api](https://github.com/googleapis/google-api-go-client) from 0.282.0 to 0.283.0.
- [Release notes](https://github.com/googleapis/google-api-go-client/releases)
- [Changelog](https://github.com/googleapis/google-api-go-client/blob/main/CHANGES.md)
- [Commits](https://github.com/googleapis/google-api-go-client/compare/v0.282.0...v0.283.0)

---
updated-dependencies:
- dependency-name: google.golang.org/api
  dependency-version: 0.283.0
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Bumps [github.com/aws/smithy-go](https://github.com/aws/smithy-go) from 1.26.0 to 1.27.2.
- [Release notes](https://github.com/aws/smithy-go/releases)
- [Changelog](https://github.com/aws/smithy-go/blob/main/CHANGELOG.md)
- [Commits](https://github.com/aws/smithy-go/compare/v1.26.0...v1.27.2)

---
updated-dependencies:
- dependency-name: github.com/aws/smithy-go
  dependency-version: 1.27.2
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Re-processing the off-chain metadata of an already-stored voting anchor
duplicated its child rows (off_chain_vote_drep_data, off_chain_vote_author,
off_chain_vote_reference, off_chain_vote_external_update,
off_chain_vote_gov_action_data). The parent insert used ON CONFLICT DO
UPDATE ... RETURNING id, so a re-fetch returned the existing id, and the
children - which have no uniqueness and were plain-inserted - were written
again.

Make insertion idempotent: insertBulkOffChainVoteDataReturningNew uses ON
CONFLICT DO NOTHING RETURNING (voting_anchor_id, hash, id) so only newly
inserted parents come back, and the orchestration inserts child rows only
for those, matched by natural key. Adds a WithResultBulkColumns result mode
for a custom RETURNING column list. Prevents new duplicates; existing rows
on synced DBs are unaffected.

Adds a regression test (cardano-db test-db) asserting a re-fetch creates no
duplicate child rows.

Signed-off-by: Chris Gianelloni <[email protected]>

Signed-off-by: Chris Gianelloni <[email protected]>

Bumps [github.com/blinklabs-io/gouroboros](https://github.com/blinklabs-io/gouroboros) from 0.153.1 to 0.181.0.
- [Release notes](https://github.com/blinklabs-io/gouroboros/releases)
- [Changelog](https://github.com/blinklabs-io/gouroboros/blob/main/RELEASE_NOTES.md)
- [Commits](https://github.com/blinklabs-io/gouroboros/compare/v0.153.1...v0.181.0)

---
updated-dependencies:
- dependency-name: github.com/blinklabs-io/gouroboros
  dependency-version: 0.181.0
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [github.com/blinklabs-io/cardano-models](https://github.com/blinklabs-io/cardano-models) from 0.7.0 to 0.7.1.
- [Release notes](https://github.com/blinklabs-io/cardano-models/releases)
- [Commits](https://github.com/blinklabs-io/cardano-models/compare/v0.7.0...v0.7.1)

---
updated-dependencies:
- dependency-name: github.com/blinklabs-io/cardano-models
  dependency-version: 0.7.1
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

Signed-off-by: Chris Gianelloni <[email protected]>

Signed-off-by: Chris Gianelloni <[email protected]>

Signed-off-by: Akhil Repala <[email protected]>

Signed-off-by: Akhil Repala <[email protected]>

The in-memory store opened "file::memory:?cache=shared", an anonymous
shared-cache URI that SQLite resolves to a single process-global
database. Every store built via New("", ...) therefore shared one set of
tables, so the metadata tests were safe only because they ran serially.

Give each in-memory store a unique database name
("file:dingo_memdb_<N>?mode=memory&cache=shared") so connections within a
store still share, but separate stores are isolated, and mark the
package's tests t.Parallel(). The file-based production path is unchanged.

Cuts the package from ~31s to ~11s (-parallel=8) and the -race run
(make test) from 512s to 257s, race-clean.

Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>
Signed-off-by: Chris Guiney <[email protected]>

Signed-off-by: Tripura Repalle <[email protected]>