delete and deleteFrom are confusing about fluentpdo HOT 4 CLOSED

@beaudesigns I know we talk about it already, but this still don't like me...

what do you think about it? I still thinking about add alias insert() === insertInto() and also this ...

Actual implementation is more strict, but this is more natural.

from fluentpdo.

I agree that having ->delete() & ->deleteFrom() might be confusing, it would be better to simplify it down to 1 that handles everything.

I personally think ->deleteFrom() and ->insertInto() are more natural, but that's because I'm familiar with SQL, and that's how I would write it in SQL.

But for Fluent, I think using ->delete('table')->where('id', 1); makes sense as well. My only concern is that it reads like you are deleting the table, not deleting FROM the table.

from fluentpdo.

Ok, let both version. but this DELETE t WHERE .... is not valid MySql syntax. In MySQL is used DROP for delete table, in postgre not?

I suggest let delete and deleteFrom but if somebody use delete without from then will be translated to DELETE FROM table. Do you agree?

from fluentpdo.

Yes, either it should be translated to DELETE FROM TABLE, or an error thrown when it is tried to run without FROM.

from fluentpdo.