Various (random) questions about the syntax about functional-orm HOT 4 CLOSED

We discussed it further in private messages. I'll release 0.1v and then we can test and brainstorm.

from functional-orm.

1. It's just an experiment to see if I was able to bend the type system to the extent I needed.
   In the end, my conclusion was that trying to keep it functional in TypeScript is really difficult and probably not worth it, and using a fluent-api (chaining) would be more beneficial and natural to most users.

2. I didn't yet design the API, see answer AD 1. However, I was thinking of mimicking knex.js approach in this matter:

from(USER)
  .join(POST, [USER.columns.id, '=', COMMENT.columns.post_id])
  .select(USER.columns.id, COMMENT.columns.text)

3. Yeah, definitely, querying the database is also a side-effect, so there isn't much difference here :)

4. Yeah, definitely.

There are two main goals for now:

• redesign the API to make it easier to reason about and type in a typesafe manner
• write a script which works with PostgreSQL which generates typesafe models for the needs of this library

from functional-orm.

OK, that's great!

I'd also love to see a first-class support not only for tables, but also for views and materialized views along with other PostgreSQL specific features. For that reason, maybe we could use the table keyword in place of the from, so that we could then also use view etc.

Another idea would be to drop the execute and treat the pipe as the actual function i.e.

const query = pipe(
  table(Comment),
  join(Post), // Rails-like convention, otherwise it's needed to define the `on`
  select([Comment.id, Comment.content, Post.title]), // or variadic
);

const result = await query();

Just brainstorming here. There are some issues here, but hopefully this will eventually lead us to the correct solution. ;)

I also wonder if it will be possible to properly type the input for inserts in TypeScript...

from functional-orm.

@mmiszy I'm closing this as there's already a plan in place. We can discuss specific things in dedicated issues.

from functional-orm.