create constant temporary table out of a meta instance
Open
Nobody has claimed this yet.
- Dominant language
- Scala
- Stars
- 2.2k
- Forks
- 379
- Avg merge
- 14m
- Merged PRs (30d)
- 8
Description
Postgress allows creation of constant (temporary) tables for use in queries with this syntax:
WITH names (id, name) AS (VALUES (1, 'ABC'), (2, 'BCD'))
SELECT id FROM names
or the inlined version:
SELECT id FROM (VALUES (1, 'ABC'), (2, 'BCD')) AS t (id, name);
assuming I have an instance of a Meta[T], is there a way of writing a generic function that takes NonEmptyList[T] and creates me a table of T values.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are identified. Start by locating the PostgreSQL-specific SQL construction and the Meta[T] abstractions, then determine whether a generic NonEmptyList[T] table representation can fit the existing API. Done would mean a decided API design with coverage for the shown VALUES forms.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, scala
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100