Comments (1)
Yes, the join()
operation returns a struct for each table. Joining two tables creates two structs.
From the docs (https://preql.readthedocs.io/en/latest/preql-modules.html#join):
Returns: A new table, where each column is a struct representing one of the joined tables.
When you do join_result{...n}
, you are telling Preql to inline the struct called n
. You could also do join_result{n.item}
, with a similar result in that case.
In Preql, my_table {...}
is essentially a no-op, which just returns all the columns. If they are structs, they will remain structs.
I hope it's clearer now.
If you have suggestions on how to improve the docs or tutorial, I'll be happy to hear them.
edit: You can also do join_result{...n, ...c}
, which will inline both structs.
from preql.
Related Issues (19)
- Add Automatic joins via attribute access
- Add support for VSCode
- Automatically generate GraphQL interface
- Grammar railroad diagram HOT 2
- Incorrect SQL code generated HOT 6
- Add support for BigQuery
- Error on saving table to BigQuery - required field id cannot be null HOT 1
- Error on saving table to BigQuery - type mismatch HOT 4
- Assertion error with BigQuery when running .pql scripts but not REPL HOT 1
- Add support for RedShift
- create conda package HOT 3
- ModuleNotFoundError: No module named 'preql.core' HOT 1
- Add support for JSON functions and operators in queries
- OracleInterface not working with TNSNAMES HOT 3
- Implement multiple-dispatch for functions
- `random()` is evaluated multiple times HOT 2
- Provide a way to specify data when executing a script directly HOT 4
- whitespace in table name HOT 12
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from preql.