Paper Citation Record · LEDGER

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents

As of 11 August 2026, this Paper Citation Record lists 20 of 20 outbound references and 1 inbound Pith citation observation for arXiv:2606.00547.

A citation records a reference. It does not transfer a finding from one paper to another.

pith.paper-citation-record.v1
2606.00547 v1

Coverage vector

measured 20 of 20 reference resolution

Typed states for the displayed outbound observations.

Source: paper_references, paper_reference_links, observed 2026-06-28T19:05:23.551551Z

measured 21 of 21 standing notices

One-hop event checks from named stored sources.

Source: scholarly_work_events, retraction_status_cache, observed 2026-08-11T06:34:44.6726+00:00

measured 1 of 1 inbound itemization

Pith citing papers itemized under the disclosed page cap.

Source: paper_references, paper_reference_links, observed 2026-08-10T12:45:16.731587Z

measured 0 of 1 external citation measurements

A source-named dated measurement, never combined with another source.

Source: pith, observed 2026-08-10T12:45:17.086794Z

Reference resolution

20 of 20 outbound references displayed

verified exact0
verified fuzzy0
unresolved16
parse uncertain0
malformed identifier0
metadata mismatch4

External citation measurements

No source-named external measurement is stored.

Outbound references

Observation 6db946c2-3e72-4679-8079-7a53451f7c71 · outbound

This paper cites InFindings of the Association for Computational Linguistics: EMNLP 2020, pages 4870–4888, Online.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents InFindings of the Association for Computational Linguistics: EMNLP 2020, pages 4870–4888, Online

Reference 1

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation ccb3e725-0413-459e-8f62-59755b48ce12 · outbound

This paper cites SimpleMem: Efficient Lifelong Memory for LLM Agents.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents SimpleMem: Efficient Lifelong Memory for LLM Agents

Reference 2

Resolution: metadata mismatch; local_arxiv, observed 2026-06-28T19:12:35.009551Z

Source-reported events for the cited work

No event found in the named queried sources as of 2026-08-11T06:34:44.6726+00:00.

Observation 32de5dd7-2bc7-4df3-b5de-4cce40a352f7 · outbound

This paper cites InProceedings of the 62nd Annual Meeting of the Association for Computational Linguistics (V olume 1: Long Papers), pages 13851– 13870.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents InProceedings of the 62nd Annual Meeting of the Association for Computational Linguistics (V olume 1: Long Papers), pages 13851– 13870

Reference 3

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 490d8d8b-ed5d-418e-a399-40f7049b4c17 · outbound

This paper cites OpenAI GPT-5 System Card.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents OpenAI GPT-5 System Card

Reference 4

Resolution: metadata mismatch; local_arxiv, observed 2026-06-28T19:12:35.011954Z

Source-reported events for the cited work

No event found in the named queried sources as of 2026-08-11T06:34:44.6726+00:00.

Observation 48332440-24db-4fc5-8a12-ab4bbec79c1a · outbound

This paper cites Qwen3 Technical Report.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents Qwen3 Technical Report

Reference 5

Resolution: metadata mismatch; local_arxiv, observed 2026-06-28T19:12:35.016387Z

Source-reported events for the cited work

No event found in the named queried sources as of 2026-08-11T06:34:44.6726+00:00.

Observation 91113d1b-c827-4f10-8bd8-8422ed954e55 · outbound

This paper cites Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning

Reference 6

Resolution: metadata mismatch; local_arxiv, observed 2026-06-28T19:12:35.014154Z

Source-reported events for the cited work

No event found in the named queried sources as of 2026-08-11T06:34:44.6726+00:00.

Observation 5e4a9814-5aba-4c3c-9519-8c344d424059 · outbound

This paper cites The user will test your SQL correctness and give you feedback.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents The user will test your SQL correctness and give you feedback

Reference 7

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 5f55fe12-c0a4-499a-8543-24c55ba3245b · outbound

This paper cites Observation.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents Observation

Reference 8

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 735839b1-cdbf-4842-9c34-a40da7907a41 · outbound

This paper cites an unresolved cited work.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents Unresolved cited work

Reference 9

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation eae510e9-434d-48c9-b6b0-a02ebdc97c90 · outbound

This paper cites an unresolved cited work.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents Unresolved cited work

Reference 10

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 35b7732c-821f-41a0-b9c5-e48e16edb8c6 · outbound

This paper cites gap_key":.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents gap_key":

Reference 11

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 68a961b0-2db1-4975-9ba1-ada8ceca69c6 · outbound

This paper cites - current_query_context: the query plus any clarifications so far.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - current_query_context: the query plus any clarifications so far

Reference 12

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation e1fbd719-fc6e-4bfc-a51e-ad8f0640a472 · outbound

This paper cites TOOL:EXECUTE SQL:[...].

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents TOOL:EXECUTE SQL:[...]

Reference 13

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 0e62a2dc-e1fc-4ef4-997d-8a786d840739 · outbound

This paper cites - 0 = completely different situation; the memory comes from an unrelated context.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - 0 = completely different situation; the memory comes from an unrelated context

Reference 14

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 68243417-214b-4bbb-87e6-1fa20e177314 · outbound

This paper cites - 0 = the memory provides essentially no actionable guidance here.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - 0 = the memory provides essentially no actionable guidance here

Reference 15

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation e281dc92-644e-446d-b153-977823765208 · outbound

This paper cites - 5 = broadly applicable pattern for many similar Text-to-SQL situations.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - 5 = broadly applicable pattern for many similar Text-to-SQL situations

Reference 16

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 8f15f8c1-ee22-4cbb-92c2-4562ed52ea97 · outbound

This paper cites - 5 = clear and trustworthy signal.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - 5 = clear and trustworthy signal

Reference 17

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation b571d89e-771d-4da9-8d94-94f87d62c95f · outbound

This paper cites tip text.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents tip text

Reference 18

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation 0fde7fa1-f272-4151-a1ed-bc5693ee49c0 · outbound

This paper cites - 0 = extremely uncertain; the scores above are mostly guesses.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents - 0 = extremely uncertain; the scores above are mostly guesses

Reference 19

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Observation f7057b41-bbdb-494e-80b5-4a2ebabcf459 · outbound

This paper cites do NOT repeat this mistake.

Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents do NOT repeat this mistake

Reference 20

Resolution: unresolved; no resolver link, observed 2026-06-28T19:05:23.551551Z

Source-reported events for the cited work

Unavailable: canonical work link unavailable.

Pith citing papers

Observation d46f119f-c4e2-43b9-9d68-fd6f78fdaf71 · inbound

From Test-Time Scaling to Reusable Memory: Measuring Crystallization in Text-to-SQL cites this paper.

From Test-Time Scaling to Reusable Memory: Measuring Crystallization in Text-to-SQL Learning to Retrieve: Dual-Level Long-Term Memory for Text-to-SQL Agents

Reference 48

Resolution: verified exact; local_arxiv, observed 2026-08-10T12:45:17.090715Z

Source-reported events for the cited work

No event found in the named queried sources as of 2026-08-11T06:34:44.6726+00:00.